| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |
| Date: | 2011-03-09 15:31:56 |
| Message-ID: | 24275.1299684716@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Andrew Sullivan <ajs(at)crankycanuck(dot)ca> 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 sometimes surprises people because of its matching rules.
If it is asking for a password, and password authentication is what's
supposed to be used, then pg_hba is not where the problem is. What
I think is that the OP has placed his client-side pgpass file in the
wrong place, or given it the wrong name, or the wrong permissions,
or the wrong contents.
I'm not too sure what the right name or place is on Windows, though,
so I have to defer to those who use that platform for more detailed
help.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2011-03-09 15:42:08 | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |
| Previous Message | Tom Lane | 2011-03-09 15:27:58 | Re: Advise on dropping TEMP table/schema for my use case |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2011-03-09 15:42:08 | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |
| Previous Message | John Edens | 2011-03-09 15:31:16 | How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |