Re: pgAdmin corrupts pgpass.conf on windows - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAdmin corrupts pgpass.conf on windows
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4013881DE@ratbert.vale-housing.co.uk
Whole thread Raw
In response to pgAdmin corrupts pgpass.conf on windows  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgadmin-support

> -----Original Message-----
> From: George Pavlov [mailto:gpavlov@mynewplace.com]
> Sent: 16 May 2006 00:51
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] pgAdmin corrupts pgpass.conf on windows
>
> > If you remove your file altogether and just let pgAdmin manage it
> > itself, does it then corrupt it as well?
>
> I tried that for a bit a while ago and I did not see any
> corruption, but I am not sure my tests were exhaustive. The
> problem is that that is really not a solution for me because
> I want to be able to have many more server/port/user/password
> combinations stored in there for psql/script purposes than
> the few that I need for pgAdmin. For a while I thought that
> my comment lines (starting with #) were confusing pgAdmin but
> it seems to do the rearranging with or without comments in
> there. Another workaround would be to never let pgAdmin store
> passwords -- that does help although pgAdmin still seems to
> touch the file (it does not mess it up as bad). If I have to
> I would take this approach because for my purposes psql
> scripts/pg_dump/pg_restore are primary to pgAdmin. I was just
> hoping for a way for the two to coexist peacefully (and also
> to be able to reuse my Linux .pgpass on Windows).

OK, I think I've found the bug and fixed it - can I mail you an updated
.exe to try?

Regards, Dave.


pgadmin-support by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: pgAdmin corrupts pgpass.conf on windows
Next
From: "Hank Hsiung"
Date:
Subject: autovacuum?