We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit).
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
1. Is this a 64bit issue? If the
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
pg_hba sometimes surprises people because of
On Wednesday, March 09, 2011 5:58:20 am Sandy Test wrote:
2. Is there a way of running a dos script that would run the pg_dump
providing a password when prompted?
Using .pgpass
http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html
Thanks
Sandy Test
--
Adrian
Andrew Sullivan a...@crankycanuck.ca writes:
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
We want to be able to run a nightly backup using the pg_dump command.
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
It still asks for a password.
On Wed, Mar 09, 2011 at 10:31:56AM -0500, Tom Lane wrote:
Andrew Sullivan a...@crankycanuck.ca writes:
On Wed, Mar 09, 2011 at 03:58:20PM +0200, Sandy Test wrote:
Unfortunately, even with the pg_hba.conf fix of adding host postgres ...
trust,
If it is asking for a password, and password