Escaping : and \ in pgpass - Mailing list pgadmin-support

From Kevin Locke
Subject Escaping : and \ in pgpass
Date
Msg-id 20130218161932.GC7651@kevinzilla
Whole thread Raw
Responses Re: Escaping : and \ in pgpass
List 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@kevinlocke.name   | JIM:  kevinoid@jabber.org
Kevin        |  http://kevinlocke.name  | IRC: kevinoid on freenode



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: 1.16.1: many operations cause display tree to collapse
Next
From: Dave Page
Date:
Subject: Re: pgAdmin 1.16.1: bug forbid unset "superuser" role