[GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Sandy Test
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

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Andrew Sullivan
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

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Adrian Klaver
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

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Tom Lane
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.

Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Andrew Sullivan
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