Folks, did we ever find the cause of this problem?
---------------------------------------------------------------------------
Garrett Heaver wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1751
> Logged by: Garrett Heaver
> Email address: garrett.heaver@researchandmarkets.com
> PostgreSQL version: 8.0.3
> Operating system: Win2K & WinXP
> Description: pg_restore bug
> Details:
>
> Hi.
>
> I'm sure you're probably aware of this issue already but pg_restore doesn't
> function correctly on the win32 builds and exists with
>
> pg_restore: [archiver (db)] connection to database "xxxxxx" failed: FATAL:
> password authentication failed for user "postgres"
>
> The password is correct and works for all other tools (psql, pg_dump, etc).
> When the pg_hba config file is changed to 'trust' everything on the
> localhost it executes as intended.
>
> I've done a bit of research on forums and seen a few other users
> experiencing the same problem.
>
> http://pgfoundry.org/forum/message.php?msg_id=1000450
>
> Thanks
> Garrett Heaver
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073