From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8
Date: Wed, 09 Mar 2011 10:31:56 -0500
Message-ID: <24275.1299684716@sss.pgh.pa.us> (raw)
In-Reply-To: <20110309144810.GP32629@shinkuro.com>
References: <10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il>
<20110309144810.GP32629@shinkuro.com>
Andrew Sullivan <ajs@crankycanuck.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ajs@crankycanuck.ca, pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8
In-Reply-To: <24275.1299684716@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox