Postgres Pro
Downloads
Home   >   mailing lists

BUG #5921: pg_dump asks for password - Mailing list pgsql-bugs

From sandyt
Subject BUG #5921: pg_dump asks for password
Date
Msg-id 201103091404.p29E4PIJ089260@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5921: pg_dump asks for password  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5921
Logged by:          sandyt
Email address:      sandy@mcw.co.il
PostgreSQL version: 8.3.8
Operating system:   windows 2008 server (64 bit)
Description:        pg_dump asks for password
Details:

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

pgsql-bugs by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: backup using pg_dump postgreSQL 8.3.8
Next
From: Robert Haas
Date:
Subject: Re: CREATEROLE does not permit commenting on newly-created roles