Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect

Just as a FYI, having trust in the pg_hba.conf file on win32 is normally
not needed for PGLA to backup a database, I have been unable to
reproduce the error Michael experienced while running on XP sp 2, the
only thing I can think of was the version of pg_dump.exe I was shipping
was corrupted or something (8.0.2).

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.

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.