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

From George Pavlov
Subject pgAdmin corrupts pgpass.conf on windows
Date
Msg-id 8C5B026B51B6854CBE88121DBF097A8612041E@ehost010-33.exch010.intermedia.net
Whole thread Raw
List pgadmin-support
Is this a known problem? Is there a fix for it? It seems that pgAdmin
(v.1.4.1 for sure, but I think some prior versions as well) on Windows
corrupt the pgpass.conf file by deleting existing entries and adding
"garbage" ones. This is not a huge problem for pgAdmin itself, although
this presents itself as pgAdmin "forgetting" the password that it had
previously remembered for you and making you type it again -- a minor
annoyance. Where it ends up being really disruptive for me is that it
trips my psql runs and various scripts that rely on my passwords being
set.

Are there any plans to fix the problem? Is it at all possible to change
the behavior so that psql and pgAdmin to not rely on the same
pgpass.conf? Is there any configuration variable that I can set for
pgAdmin to make it point to a different pgpass.conf

As an example, below is my actual pgpass.conf file as of today after a
few battles between pgAdmin and psql for control over it (I have changed
usernames and passwords to protect the innocent). And no, I do not have
a server named "7" -- these are just truncated garbage lines inserted by
pgAdmin. the sequences of #s are places where pgAdmin has deleted the
lines after the comment, so it used to look like this:

#
servername1:5432:*:moo:goo
servername1:5432:*:gai:pan
#
servername2:5432:*:moo:goo
servername2:5432:*:gai:pan

and pgAdmin made it look like this:

#
#


Here are the complete pgpass file contents:

-----------------------------------------------------
#
#
#
localhost:5432:*:foo:foo
#
dev07:5432:*:moo:moo
dev07:5432:*:foo:foo
#
#
#
192.168.68.67:5432:*:foo:foo
#
localhost:5435:*:foo:foo
#
localhost:5436:*:foo:foo
#
localhost:5437:*:moo:moo
localhost:5437:*:foo:foo
#
7:*:foo:foo
#
7:*:foo:foo
#
:foo
#
7:*:foo:foo
#
7:*:foo:foo
#
192.168.68.65:5432:*:foo:foo
dev03:5432:*:moo:moo
res:foo
dev03:5432:*:moo:moo
res:foo
dev03:5432:*:moo:moo
es
dev03:5432:*:moo:moo
localhost:5435:*:moo:moo
localhost:5435:*:moo:moo
localhost:5435:*:moo:moo
-----------------------------------------------------


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Interval with precision
Next
From: "Dave Page"
Date:
Subject: Re: pgAdmin corrupts pgpass.conf on windows