| 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: | Whole Thread | Raw Message | 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 |