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 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 authentica

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

2011-03-09 Thread Tom Lane
Andrew Sullivan 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. > pg_hba s

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 > -

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 becaus

[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 serve