Hello.
I have a strange problem when trying to use pg_restore to restore data from
a backup, on WIN XP, PostgreSQL 8.0.3.
If I use PgAdmin it works, but if I copy the command to .bat file
authentication fails although I enter correct password.
The .bat script is the following:
cd D:\Program Files\PostgreSQL\8.0\bin
pg_restore.exe -i -h localhost -p 5432 -U postgres -d
"MYDATABASE" -a --disable-triggers -t mytablename -v
"C:\BACKUP\MYDATABASE_DATA_BCP_Fc.fcbackup"
and the error is:
pg_restore: [archiver (db)] connection to database "MYDATABASE" failed:
FATAL: password authentication failed for user "postgres"
I also tried to pass password by pgpass.conf file, but without result. If I
use PgAdmin, it works....
What could be the reason ? Is this a bug ?
Zlatko