DOS-style line endings in .pgpass
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2016-11-14T19:31:22Z
Lists: pgsql-bugs
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. -- -- Josh Berkus Red Hat OSAS (any opinions are my own)