Обсуждение: backup using pg_dump postgreSQL 8.3.8

We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit).

=20

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,=20

It still asks for a password.

=20

1. Is this a 64bit issue? If the server was 32bit, would it not ask for
a password?

=20

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

=20

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

=20

Thanks

=20

Sandy Test

System Manager Makhteshim

IT

Makhteshim Agan Group

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

sandy.test@ma-industries.com

=20

On Wed, 2011-03-09 at 15:05 +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.

Please post this to pgsql-general or pgsql-admin lists.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz