Hello PostgreSQL developers,
I just got the bug report below from a Debian user. The comment on
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html
confirms this, it describes the exact same problem.
Thank you,
Martin
----- Forwarded message from David <[EMAIL PROTECTED]> -----
X-Spam-Status: No, score=0.0 required=4.0 tests=BAYES_50,UNPARSEABLE_RELAY
autolearn=no version=3.1.7-deb
Subject: Bug#425125: postgresql-8.1: localhost does not work for unix sockets
in ~/.pgpass
Reply-To: David <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Date: Sat, 19 May 2007 12:10:18 +0200
From: David <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Package: postgresql-8.1
Version: 8.1.8-1
Severity: normal
According to this page:
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html
"A hostname of localhost matches both host (TCP) and local (Unix domain
socket) connections coming from the local machine."
However that does not work for me. I get prompted for a password. I
have to put '*' in the hostname section to allow passwordless local
unix socket connections.
eg:
Works: *:*:david:david:moo
Does not work: localhost:*:david:david:moo
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (990, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core)
Locale: LANG=en_ZA, LC_CTYPE=en_ZA (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
-- no debconf information
----- End forwarded message -----
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
