Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4E7BC1337B9C for ; Wed, 9 Mar 2011 11:32:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 52609-05; Wed, 9 Mar 2011 15:31:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 7BAC91337B93; Wed, 9 Mar 2011 11:31:56 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p29FVu2G024276; Wed, 9 Mar 2011 10:31:56 -0500 (EST) To: Andrew Sullivan cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 In-reply-to: <20110309144810.GP32629@shinkuro.com> References: <10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il> <20110309144810.GP32629@shinkuro.com> Comments: In-reply-to Andrew Sullivan message dated "Wed, 09 Mar 2011 09:48:10 -0500" Date: Wed, 09 Mar 2011 10:31:56 -0500 Message-ID: <24275.1299684716@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/102 X-Sequence-Number: 36974 Andrew Sullivan 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