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)