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