How to run pg_dump/pg_dumpall command on Linux?

Vivek Kumar Ray picture Vivek Kumar Ray · Jun 15, 2012 · Viewed 16.7k times · Source

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.

Answer

Artem Koshelev picture Artem Koshelev · Jun 15, 2012

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.