From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Is there a bug in the win32 pg_restore (version 8.02) ? |
Date: | 2005-04-28 16:18:00 |
Message-ID: | 42710CB8.5050408@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I just tried to restore a db with the win32 pg_restore that shipped with 8.02 and I get to the part where
it prompts me for the password, and I enter it, then I get the following error:
C:\>pg_restore.exe --ignore-version --verbose --dbname=mandi_test -W -U postgres
--port=5432 --host=192.168.1.23 "C:\Documents and Settings\Administrator\Desktop
\mandi.bak"
pg_restore: connecting to database for restore
Password:
pg_restore: [archiver (db)] connection to database "mandi_test" failed: FATAL:
password authentication failed for user "postgres"
pg_restore: *** aborted because of error
I have the pg_hba.conf for my host set to md5, and if I change it to trust then I can do the restore.
update: I just tried the pg_restore that has a version number of 8.0 and it works, definately seems to be
a bug in the 8.02 version (win32)
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Mayer | 2005-04-28 16:56:10 | Re: PRIMARY KEY on a *group* of columns imply that each column is |
Previous Message | Scott Marlowe | 2005-04-28 15:34:24 | Re: Help |