How to run pg_dump/pg_dumpall command on Linux?

Question

Hello everyone i am try to create backup in postgres through dump. when i run the command through command line it wants password when i give the password it will give some error

pg_dump: [archiver (db)] connection to database "nsdgpkidb" failed: FATAL:  password authentication failed for user "root"

if any one have some valuable time please help me thanks.

score 13 · Accepted Answer · edited May 23 '17 at 12:32

13

Such kind of questions are better to ask on ServerFault. You have to provide pg_dump with the valid postgresql account via command line parameter:

pg_dump -U postgres nsdgpkidb > file.sql

By default it assumes the current local user account (root). Another way is to change the current user and issue the command.

edited May 23 '17 at 12:32

Community

1
1

answered Jun 15 '12 at 08:42

Artem Koshelev

10,548
4
36
68

where will the dump file get saved? – user1735921 Sep 03 '15 at 04:43
1

@user1735921 `> file.sql` means file.sql in the current directory, or you can use full or relative path, like `> /path/to/file/file.sql` – Artem Koshelev Sep 03 '15 at 10:23
@ArtemKoshelev server fault or [DBA](http://dba.stackexchange.com/)? ;) – abbood Jul 28 '16 at 09:16
@user1735921 you can define the path absolute: `pg_dump -U postgres name_of_BD > '/dir_to_backup/Class_international.sql'` – VyR Mar 12 '21 at 15:10

How to run pg_dump/pg_dumpall command on Linux?

1 Answers1