Home > mailing lists

FW: backup using pg_dump postgreSQL 8.3.8 - Mailing list pgsql-admin

From	Sandy Test
Subject	FW: backup using pg_dump postgreSQL 8.3.8
Date	March 9, 2011 12:56:11
Msg-id	10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il Whole thread Raw
Responses	Re: FW: backup using pg_dump postgreSQL 8.3.8 (Vibhor Kumar <vibhor.aim@gmail.com>) Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 (Andrew Sullivan <ajs@crankycanuck.ca>) Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 (Adrian Klaver <adrian.klaver@gmail.com>)
List	pgsql-admin

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 server was 32bit, would it not ask for a password?

2. Is there a way of running a dos script that would run the pg_dump providing a password when prompted?

3. Is there a way of running the pg_dump with a user that doesn't have a password?

Thanks

Sandy Test

System Manager Makhteshim

Makhteshim Agan Group

tel:972-8-6296823 fax:972-8-6296043

From: Gilberto Castillo Martínez
Date: 09 March 2011, 12:39:55
Subject: Re: Listen on IPv6 only

From: Vibhor Kumar
Date: 09 March 2011, 13:08:58
Subject: Re: FW: backup using pg_dump postgreSQL 8.3.8