Database backup from Postgres

Question

I have postgresql installed in my Ubuntu 16.04 system. I am trying to take back up of database but it does not work,

user1@rajeshN ~ $ sudo pg_dump -U postgres teleshop_development1 > pg_backup
[sudo] password for user1: 
pg_dump: [archiver (db)] connection to database "teleshop_development1" failed: FATAL:  Peer authentication failed for user "postgres"

So I switched to postgres, And tried there but I do not know password

user1@rajeshN ~ $ sudo -i -u postgres
postgres@rajeshN:~$ 
postgres@rajeshN:~$ sudo pg_dump -U postgres teleshop_development1 > pg_backup
[sudo] password for postgres: 
Sorry, try again.

Please suggest how can I get password or back up. Thanks in advance!

Reset the password. If you can't access the pg server to reset it (because it requires a password), change the auth-method value to trust in pg_hba.conf to allow you to access without a password, then go reset it, and change auth-method back to its original value. — 404
– 404, Commented Nov 29, 2018 at 13:43
@eurotrash I read documentation of pg_hba.conf about adding IP in it. I will check. Thanks — ray
– ray, Commented Nov 29, 2018 at 13:51

C14L · Accepted Answer · 2018-11-29 13:41:41Z

2

When you are already the user "postgres", do not use sudo again. Its just

postgres@rajeshN:~$ pg_dump teleshop_development1 > pg_backup

Or you can do it all in one line

user1@rajeshN ~ $ sudo -u postgres pg_dump teleshop_development1 > pg_backup

answered Nov 29, 2018 at 13:41

C14L

12.7k4 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ray Over a year ago

How can I reset password of user postgres@Ascra:~$

Usagi Miyamoto · Accepted Answer · 2018-11-30 15:41:41Z

1

Specify PostgreSQL password, EG with -W.

See: https://www.postgresql.org/docs/9.4/app-pgdump.html

edited Nov 30, 2018 at 15:41

answered Nov 29, 2018 at 13:42

Usagi Miyamoto

6,3451 gold badge21 silver badges37 bronze badges

1 Comment

ray Over a year ago

Thanks for the info, I used @C14L answer

Collectives™ on Stack Overflow

Database backup from Postgres

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related