Re: DOS-style line endings in .pgpass

On 11/14/2016 08:31 PM, Josh Berkus wrote:
> Version Tested: 9.6.1
> Platform: Fedora 24 Docker Base Image
> Summary: DOS-style line endings (CRLF) cause .pgpass to fail.
> 
> Steps to Reproduce:
> 
> 1. Install PostgreSQL
> 2. Set up user with md5 passwords
> 3. Create pgpass file using program which makes CRLF line endings, such
>    as Python's CSV module, or windows Notepad.
> 4. Try to log in
> 5. Get:
> 
> psql: FATAL:  password authentication failed for user "postgres"
> password retrieved from file "/var/lib/pgsql/.pgpass"
> 
> What appears to be happening here is that one of the characters of the
> CRLF is being appended to the password, making it invalid.
> 
> Is this a known issue on Windows?  Or is this peculiar to Fedora?
> 
> If it's a general issue, it would be friendly to Windows devs to fix it.

Maybe something like the attached patch?
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support