|
I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB to
backup. Then, I dropped and recreated TestDB. However, I failed to restore with this command pg_restore -u
-F c -d TestDB E:\Temp\Test.tar.gz. Here is what I got : pg_restore: [archiver (db)] connection to database
"TestDB" failed: FATAL: password authentication failed for user
"postgres" I don’t understand why the password is invalid. I am
sure I used that password to create backup as well. How should I restore the gz file ? Thanks ! Tan |
