Sfrgttk

Organic chemistry Iodoform Reaction

Adding empty element to declared container without declaring type of element

Freedom of speech and where it applies

Are taller landing gear bad for aircraft, particulary large airliners?

How to deal with or prevent idle in the test team?

Word describing multiple paths to the same abstract outcome

I2C signal and power over long range (10meter cable)

Identify a stage play about a VR experience in which participants are encouraged to simulate performing horrific activities

What was required to accept "troll"?

How do I repair my stair bannister?

Can I rely on these GitHub repository files?

The most efficient algorithm to find all possible integer pairs which sum to a given integer

Bob has never been a M before

Should a half Jewish man be discouraged from marrying a Jewess?

Is there a good way to store credentials outside of a password manager?

A workplace installs custom certificates on personal devices, can this be used to decrypt HTTPS traffic?

What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution?

What will be the benefits of Brexit?

Calculating the number of days between 2 dates in Excel

Can I use my Chinese passport to enter China after I acquired another citizenship?

Should my PhD thesis be submitted under my legal name?

Would it be legal for a US State to ban exports of a natural resource?

Installing PowerShell on 32-bit Kali OS fails

Is there enough fresh water in the world to eradicate the drinking water crisis?

Cannot restore postgres dump file

pg_restore and psql asks password for restoring dump filedatabase not restoring from dump fileWhy can't I restore the DB from an SQL dump in PostgreSQL 9.4 (problem with dblink)?Permission denied to create “pg_catalog.tablename” during pg_dump targetting another machineSequence number shows a lower value after dump file importRestore/import tables from unsuccessful database dump fileWarning Console code page (437) differs from Windows code page (1252). 8-bit characters might not work correctly in PostgreSQLPostgreSQL dump and restoreMissing tables from MySQL restoreDuring restore restart, an I/O error occurred on checkpoint file

0

When i try to restore a database from a dump file using the following command:

 i C:/pathname/dumpfile.txt

from within my sql shell, it runs the first few lines of the dump file and then I get the following error:

ERROR: permission denied to create "pg_catalog.databasename"

DETAIL: System catalog modifications are currently disallowed.

This shows the beginning of the dump file. I think the CREATE TABLE command triggers the error.

I'm using postgreSQL Version 11.1.
Any ideas how to solve this?

postgresql restore dump

share|improve this question

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you created an empty schema for your data? Maybe you could try that?
  
  – Vérace
  Jan 5 at 15:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  But then how do I restore the dump into this empty schema?
  
  – Cyrill
  Jan 5 at 17:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you still have access to the old database? if so, redo the dump using the pg_dump from 11.1, not from 9.6.0.
  
  – jjanes
  Jan 5 at 18:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unless you changed the setting of "log_min_error_statement", you shouldn't have to guess what statement triggered the ERROR. The ERROR message will include the triggering statement. Using the default log format, it will be flagged with "STATEMENT:"
  
  – jjanes
  Jan 5 at 18:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't have access to the old database so I can't redo the dump. I tried to restore it using Version 9.6.0 though, but that didn't work either.
  
  – Cyrill
  Jan 6 at 8:31
  

  
  
  
  

 | 
show 1 more comment

0

When i try to restore a database from a dump file using the following command:

 i C:/pathname/dumpfile.txt

from within my sql shell, it runs the first few lines of the dump file and then I get the following error:

ERROR: permission denied to create "pg_catalog.databasename"

DETAIL: System catalog modifications are currently disallowed.

This shows the beginning of the dump file. I think the CREATE TABLE command triggers the error.

I'm using postgreSQL Version 11.1.
Any ideas how to solve this?

postgresql restore dump

share|improve this question

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Have you created an empty schema for your data? Maybe you could try that?
  
  – Vérace
  Jan 5 at 15:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  But then how do I restore the dump into this empty schema?
  
  – Cyrill
  Jan 5 at 17:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you still have access to the old database? if so, redo the dump using the pg_dump from 11.1, not from 9.6.0.
  
  – jjanes
  Jan 5 at 18:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Unless you changed the setting of "log_min_error_statement", you shouldn't have to guess what statement triggered the ERROR. The ERROR message will include the triggering statement. Using the default log format, it will be flagged with "STATEMENT:"
  
  – jjanes
  Jan 5 at 18:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't have access to the old database so I can't redo the dump. I tried to restore it using Version 9.6.0 though, but that didn't work either.
  
  – Cyrill
  Jan 6 at 8:31
  

  
  
  
  

 | 
show 1 more comment

When i try to restore a database from a dump file using the following command:

 i C:/pathname/dumpfile.txt

from within my sql shell, it runs the first few lines of the dump file and then I get the following error:

ERROR: permission denied to create "pg_catalog.databasename"

DETAIL: System catalog modifications are currently disallowed.

This shows the beginning of the dump file. I think the CREATE TABLE command triggers the error.

I'm using postgreSQL Version 11.1.
Any ideas how to solve this?

postgresql restore dump

share|improve this question

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

 i C:/pathname/dumpfile.txt

share|improve this question

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

share|improve this question

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

edited Jan 6 at 1:30

Mario Mitterbauer

1053

edited Jan 6 at 1:30

Mario Mitterbauer

1053

asked Jan 5 at 14:49

CyrillCyrill

111

asked Jan 5 at 14:49

CyrillCyrill

111

2 Answers
2

active

oldest

votes

1

Ok I solved it: in the following line:

SET search_path = car, pg_catalog;

apparantly, car is the name of the schema. As that schema didn't exist, it tried to create a table in the pg_catalog schema. I manually created a schema called car, and, tada..
Thanks to everybody for their support.

share|improve this answer

answered Jan 6 at 13:59

CyrillCyrill

111

add a comment | 

0

First check if you need to set the search_path (see the other answer to the question).

SET search_path = car, pg_catalog;

Then check if the schema exists. If not, then add this to your SQL dump file:

CREATE SCHEMA car;

ALTER SCHEMA car OWNER TO car;

share

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226408%2fcannot-restore-postgres-dump-file%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

Ok I solved it: in the following line:

SET search_path = car, pg_catalog;

apparantly, car is the name of the schema. As that schema didn't exist, it tried to create a table in the pg_catalog schema. I manually created a schema called car, and, tada..
Thanks to everybody for their support.

share|improve this answer

answered Jan 6 at 13:59

CyrillCyrill

111

add a comment | 

1

Ok I solved it: in the following line:

SET search_path = car, pg_catalog;

apparantly, car is the name of the schema. As that schema didn't exist, it tried to create a table in the pg_catalog schema. I manually created a schema called car, and, tada..
Thanks to everybody for their support.

share|improve this answer

answered Jan 6 at 13:59

CyrillCyrill

111

add a comment | 

Ok I solved it: in the following line:

SET search_path = car, pg_catalog;

apparantly, car is the name of the schema. As that schema didn't exist, it tried to create a table in the pg_catalog schema. I manually created a schema called car, and, tada..
Thanks to everybody for their support.

share|improve this answer

answered Jan 6 at 13:59

CyrillCyrill

111

SET search_path = car, pg_catalog;

share|improve this answer

answered Jan 6 at 13:59

CyrillCyrill

111

answered Jan 6 at 13:59

CyrillCyrill

111

answered Jan 6 at 13:59

CyrillCyrill

111

0

First check if you need to set the search_path (see the other answer to the question).

SET search_path = car, pg_catalog;

Then check if the schema exists. If not, then add this to your SQL dump file:

CREATE SCHEMA car;

ALTER SCHEMA car OWNER TO car;

share

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

First check if you need to set the search_path (see the other answer to the question).

SET search_path = car, pg_catalog;

Then check if the schema exists. If not, then add this to your SQL dump file:

CREATE SCHEMA car;

ALTER SCHEMA car OWNER TO car;

share

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

First check if you need to set the search_path (see the other answer to the question).

SET search_path = car, pg_catalog;

Then check if the schema exists. If not, then add this to your SQL dump file:

CREATE SCHEMA car;

ALTER SCHEMA car OWNER TO car;

share

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

SET search_path = car, pg_catalog;

CREATE SCHEMA car;

ALTER SCHEMA car OWNER TO car;

share

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 6 mins ago

DagmarDagmar

1012

New contributor

Dagmar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 6 mins ago

DagmarDagmar

1012