FW: backup using pg_dump postgreSQL 8.3.8

From: "Sandy Test" <sandy(at)mcw(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: FW: backup using pg_dump postgreSQL 8.3.8
Date: 2011-03-09 13:58:20
Message-ID: 10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

IT

Makhteshim Agan Group

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

sandy(dot)test(at)ma-industries(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-09 14:10:06 Re: FW: backup using pg_dump postgreSQL 8.3.8
Previous Message Gilberto Castillo Martínez 2011-03-09 13:39:53 Re: Listen on IPv6 only

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2011-03-09 14:05:39 Re: Copying data from one table to another - how to specify fields?
Previous Message Vincent Veyron 2011-03-09 13:55:42 Re: Web Hosting