From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "George Pavlov" <gpavlov(at)mynewplace(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin corrupts pgpass.conf on windows |
Date: | 2006-05-15 23:00:06 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4013881CD@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> George Pavlov
> Sent: 15 May 2006 23:17
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] pgAdmin corrupts pgpass.conf on windows
>
> 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.
No, this is not a known issue - at least not one I've ever seen.
> 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
No, because it's libpq that actually reads the file, not pgAdmin.
> 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:
>
If you remove your file altogether and just let pgAdmin manage it
itself, does it then corrupt it as well?
What characterset/locale etc. does your copy of Windows run in?
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | George Pavlov | 2006-05-15 23:51:12 | Re: pgAdmin corrupts pgpass.conf on windows |
Previous Message | George Pavlov | 2006-05-15 22:17:02 | pgAdmin corrupts pgpass.conf on windows |