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?
Thanks,
Tony
Michael Schmidt wrote:
In an earlier post, I mentioned that PG Lightning Admin seemed to
hang when I did a dump. Mr. Caduto provided some help with this and
the problem was resolved by setting my connection to "trust" in
hba.conf.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
