Joshua D. Drake wrote:
on another note it seems that the only version of pg_restore.exe that
will accept a password from the command line is 8.0.0.
All later versions prompt for the password, but fail every single
time. The only way to restore a file on anything above 8.0.0
(pg_restore) is to have the pg_hba.conf file set to trust.
If the above is true could you please build a test case and submit it
to hackers?
Joshua,
Looks like it's already been reported back in July:
http://groups.google.com/group/pgsql.bugs/browse_thread/thread/e47b7e96584c1d3c/8e7e2846222732fe?lnk=st&q=pg_restore+password+authentication+failed&rnum=2&hl=en#8e7e2846222732fe
Maybe it fell through the cracks.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
