From: | Kevin Locke <kevin(at)kevinlocke(dot)name> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Escaping : and \ in pgpass |
Date: | 2013-02-18 16:19:32 |
Message-ID: | 20130218161932.GC7651@kevinzilla |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello All,
It appears that the way pgAdmin parses pgpass differs from the format
documented for libpq[1] with respect to escaping : and \ characters.
I noticed the difference when version 1.14.2 ignored my (escaped)
pgpass entry for ::1 which was as follows:
\:\:1:5432:*:username:password
From what I can tell from looking at the current git sources, this
would occur from escapes in IPv6 addresses and usernames or passwords
with escaped : or \.
The IPv6 case is not too serious as psql will accept addresses without
escapes as well (I haven't tested username/passwords). I just wanted
to bring it to your attention.
If you decide to change the behavior, you may want to note that libpq
changed its unescaping behavior in 9.2 as a result of this[2] ML
thread.
1. http://www.postgresql.org/docs/current/static/libpq-pgpass.html
2. http://www.postgresql.org/message-id/20111217082754.GB30887@rice.edu
--
Cheers, | kevin(at)kevinlocke(dot)name | JIM: kevinoid(at)jabber(dot)org
Kevin | http://kevinlocke.name | IRC: kevinoid on freenode
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2013-02-18 16:38:22 | Re: pgAdmin 1.16.1: bug forbid unset "superuser" role |
Previous Message | Dave Page | 2013-02-18 16:19:27 | Re: 1.16.1: many operations cause display tree to collapse |