Postgresql-9.6 backup
I have to backup a PostgreSQL database using this command:
sudo pg_dumpall -a mydb > app111618.bak
After I type that command, I get this error:
`pg_dumpall: too many command-line arguments (first is "mydb")`
In the command it say this:
Try
pg_dumpall --helpfor more information.
How can I fix this?
postgresql-9.6
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
add a comment |
I have to backup a PostgreSQL database using this command:
sudo pg_dumpall -a mydb > app111618.bak
After I type that command, I get this error:
`pg_dumpall: too many command-line arguments (first is "mydb")`
In the command it say this:
Try
pg_dumpall --helpfor more information.
How can I fix this?
postgresql-9.6
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
add a comment |
I have to backup a PostgreSQL database using this command:
sudo pg_dumpall -a mydb > app111618.bak
After I type that command, I get this error:
`pg_dumpall: too many command-line arguments (first is "mydb")`
In the command it say this:
Try
pg_dumpall --helpfor more information.
How can I fix this?
postgresql-9.6
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
I have to backup a PostgreSQL database using this command:
sudo pg_dumpall -a mydb > app111618.bak
After I type that command, I get this error:
`pg_dumpall: too many command-line arguments (first is "mydb")`
In the command it say this:
Try
pg_dumpall --helpfor more information.
How can I fix this?
postgresql-9.6
postgresql-9.6
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
edited Nov 16 '18 at 2:40
Mozahler
2,19151927
2,19151927
asked Nov 16 '18 at 1:31
bugzzbugzz
31
asked Nov 16 '18 at 1:31
bugzzbugzz
31
asked Nov 16 '18 at 1:31
bugzzbugzz
31
31
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
pg_dumpall is a tool to dump all databases, so it doesn't support specifying a database name (assuming that mydb is the name of the database you want to dump).
If you want to dump only a single database, use pg_dump instead:
pg_dump -a mydb > app111618.bak
If you did intend to dump all databases, just leave out the database name:
pg_dumpall -a > app111618.bak
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53330204%2fpostgresql-9-6-backup%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
pg_dumpall is a tool to dump all databases, so it doesn't support specifying a database name (assuming that mydb is the name of the database you want to dump).
If you want to dump only a single database, use pg_dump instead:
pg_dump -a mydb > app111618.bak
If you did intend to dump all databases, just leave out the database name:
pg_dumpall -a > app111618.bak
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
add a comment |
pg_dumpall is a tool to dump all databases, so it doesn't support specifying a database name (assuming that mydb is the name of the database you want to dump).
If you want to dump only a single database, use pg_dump instead:
pg_dump -a mydb > app111618.bak
If you did intend to dump all databases, just leave out the database name:
pg_dumpall -a > app111618.bak
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
add a comment |
pg_dumpall is a tool to dump all databases, so it doesn't support specifying a database name (assuming that mydb is the name of the database you want to dump).
If you want to dump only a single database, use pg_dump instead:
pg_dump -a mydb > app111618.bak
If you did intend to dump all databases, just leave out the database name:
pg_dumpall -a > app111618.bak
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
pg_dumpall is a tool to dump all databases, so it doesn't support specifying a database name (assuming that mydb is the name of the database you want to dump).
If you want to dump only a single database, use pg_dump instead:
pg_dump -a mydb > app111618.bak
If you did intend to dump all databases, just leave out the database name:
pg_dumpall -a > app111618.bak
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
answered Nov 16 '18 at 8:01
a_horse_with_no_namea_horse_with_no_name
304k46465561
304k46465561
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53330204%2fpostgresql-9-6-backup%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
