From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pgadmin is changing pgpass.conf |
Date: | 2009-09-18 15:07:07 |
Message-ID: | 4AB3A21B.4090602@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Raymond O'Donnell wrote:
> On 16/09/2009 10:55, Howard Cole wrote:
>
>> Hi All,
>>
>> I have been having a few problems with my password file recently,
>> causing my scheduled pg_dump to fail. The problem is that the
>> pgpass.conf file keeps changing. Eventually I narrowed it down to using
>> pgadmin. Every time I start pgadmin, it changes the contents of my
>> pgpass file, even though I do not store my password in pgadmin.
>>
>> This only seems to have become a problem since installing 8.4 and
>> associated version of pgadmin.
>>
>> Is this the desired behaviour or is it a bug?
>>
>
> It's the desired behaviour, and is described in the pgAdmin docs. As I
> remember there was also a discussion (on the pgadmin-support list I
> think) when this feature was added, on the merits or otherwise of
> storing passwords in plain text on disk.
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
>
Hi Ray,
Thanks for the update. Unfortunately this behaviour has the side effect
of deleting passwords that I have set up in the file manually for other
applications (namely the backup), which runs under the same user
account. I guess I'll just have to come up with an alternative.
Howard.
www.selestial.com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2009-09-18 15:23:55 | Re: gap in sequence numbers |
Previous Message | Tom Lane | 2009-09-18 14:16:03 | Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)? |