我的Ubuntu 16.04系统中安装了postgresql。我正试图备份数据库,但它不起作用,

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"

所以我转到了postgres,在那里试过,但我不知道密码
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.

请建议如何获取密码或备份。提前谢谢!

最佳答案

当您已经是“postgres”用户时,不要再次使用sudo。这是公正的

postgres@rajeshN:~$ pg_dump teleshop_development1 > pg_backup

或者你可以一字排开
user1@rajeshN ~ $ sudo -u postgres pg_dump teleshop_development1 > pg_backup

关于postgresql - 从Postgres备份数据库,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/53540271/

10-12 00:21
查看更多