CODEWITHSUNDEEP
linuxpostgresqlpg-dumppg-dumpall
Vivek Kumar Ray
Vivek Kumar Ray

Reputation: 8581

How to run pg_dump/pg_dumpall command on Linux?

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.

Upvotes: 6

Views: 25266

Answers (1)

Artem Koshelev
Artem Koshelev

Reputation: 10607

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.

Upvotes: 13

Related Questions