我的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/