pgAdmin corrupts pgpass.conf on windows
От | George Pavlov |
---|---|
Тема | pgAdmin corrupts pgpass.conf on windows |
Дата | |
Msg-id | 8C5B026B51B6854CBE88121DBF097A8612041E@ehost010-33.exch010.intermedia.net обсуждение исходный текст |
Список | 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 по дате отправления: