I have verfied this bug exists in all pg_restore versions greater than 8.0.0
Someone else reported it way back in Feb:
http://groups.google.com/group/mailing.database.pgsql-bugs/browse_thread/thread/4dacdd43b894a2c3/e59e3203bb22745b?lnk=st&q=pg_restore+password+authentication+failed&rnum=9&hl=en#e59e3203bb22745b
basicly pg_restore prompts for the password, but no matter what you
enter it fails, the only way it works is to have
the server pg_hba.conf file set to trust. version 8.0.0 works, so it
was the result of some change in versions later than 8.0.0
Anyone know if this is resolved for 8.1?
Thanks,
Tony