Skip site navigation (1) Skip section navigation (2)

Re: Automated pg_Dump issue

From: Chris Campbell <ccampbell(at)cascadeds(dot)com>
To: Carlo Ascani <carlo(dot)ascani(at)2ndquadrant(dot)it>, "pgsql-novice(at)postgresql(dot)org"<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Automated pg_Dump issue
Date: 2011-09-02 13:39:57
Message-ID: 453A24085F801842AEA8D0B6B269065D012B6F2D95E7@HDMC.cds.local (view raw or flat)
Thread:
Lists: pgsql-novice
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Carlo Ascani
Sent: Friday, September 02, 2011 1:42 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Automated pg_Dump issue

On Wed, 31 Aug 2011 14:13:07 -0700
Chris Campbell <ccampbell(at)cascadeds(dot)com> wrote:

>> The call string is:
>> "c:\program files (x86)\PostgreSQL\9.0\bin\PG_dump.exe" --create
>> --no-password --format="c" --superuser="postgres"
>> --username="postgres" --file="c:\temp\pg.backup" "dd3_000"
>> 

>I'm not so strong in Windows, but specifying the -h 127.0.0.1
>option should be sufficient for you. 


Thank you for your reply.  Unfortunately it made no difference.  I've revised the call somewhat based on some other fine tuning but the password prompt remains.  And when I include the no-password parameter if fails with a no password supplied error

"c:\program files (x86)\PostgreSQL\9.0\bin\PG_dump.exe" --host="27.0.0.1" --username="postgres" --no-password --file="c:\temp\pg.backup" --disable-dollar-quoting --format=plain --inserts --column-inserts "dd3_000"

What dark magic is involved in setting the pgpass.conf file to allow pg_dump to work without a password prompt?  I set it based on the suggestion given in the older post but it doesn't seem to matter what I put in there: (localhost:5432:dd3_000:postgres:postgres)
The pgpass.conf file exists in the root of my database cluster.  Is that correct?  Thanks for any suggestions...

In response to

Responses

pgsql-novice by date

Next:From: Carlo AscaniDate: 2011-09-02 14:47:26
Subject: Re: Automated pg_Dump issue
Previous:From: Carlo AscaniDate: 2011-09-02 08:42:11
Subject: Re: Automated pg_Dump issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group