Cannot restore postgres dump filepg_restore and psql asks password for restoring dump filedatabase not...
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
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
edited Jan 6 at 1:30
Mario Mitterbauer
1053
asked Jan 5 at 14:49
CyrillCyrill
111
|
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
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
edited Jan 6 at 1:30
Mario Mitterbauer
1053
asked Jan 5 at 14:49
CyrillCyrill
111
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
postgresql restore dump
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
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
edited Jan 6 at 1:30
Mario Mitterbauer
1053
1053
asked Jan 5 at 14:49
CyrillCyrill
111
asked Jan 5 at 14:49
CyrillCyrill
111
asked Jan 5 at 14:49
CyrillCyrill
111
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
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
Have you created an empty schema for your data? Maybe you could try that?
– Vérace
Jan 5 at 15:38
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
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
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
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
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
2 Answers
2
active
oldest
votes
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.
answered Jan 6 at 13:59
CyrillCyrill
111
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;
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
});
}
});
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
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
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
answered Jan 6 at 13:59
CyrillCyrill
111
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.
answered Jan 6 at 13:59
CyrillCyrill
111
answered Jan 6 at 13:59
CyrillCyrill
111
answered Jan 6 at 13:59
CyrillCyrill
111
answered Jan 6 at 13:59
CyrillCyrill
111
111
add a comment |
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;
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;
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;
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.
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;
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
answered 6 mins ago
DagmarDagmar
1012
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.
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.
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 |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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