Thread: BUG #10437: Storing Password with a comma and/or colon in it fails use of psql, etc.

The following bug has been logged on the website:

Bug reference:      10437
Logged by:          Michael Heumann
Email address:      michael@mce-business.de
PostgreSQL version: 9.3.3
Operating system:   Windows 7
Description:

I stumbled above the following issue:
When storing a password (which happens in pgpass.conf) one can use pgAdmin,
but not psql or pg_dump.

It will always say: wrong password.
By removing the saved password everything works as expected.
Guess: Passwords including a colon and/or a comma will be interpreted
wrong.

On 05/24/2014 06:59 PM, michael@mce-business.de wrote:
> The following bug has been logged on the website:
>
> Bug reference:      10437
> Logged by:          Michael Heumann
> Email address:      michael@mce-business.de
> PostgreSQL version: 9.3.3
> Operating system:   Windows 7
> Description:
>
> I stumbled above the following issue:
> When storing a password (which happens in pgpass.conf) one can use pgAdmin,
> but not psql or pg_dump.
>
> It will always say: wrong password.
> By removing the saved password everything works as expected.
> Guess: Passwords including a colon and/or a comma will be interpreted
> wrong.

That is a correct guess, but the problem is with pgAdmin.  See this
thread:
http://www.postgresql.org/message-id/20140507043248.1398.38867%40wrigleys.postgresql.org

--
Vik