Skip site navigation (1) Skip section navigation (2)

Fwd: Bug#425125: postgresql-8.1: localhost does not work for unixsockets in ~/.pgpass

From: Martin Pitt <martin(at)piware(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Fwd: Bug#425125: postgresql-8.1: localhost does not work for unixsockets in ~/.pgpass
Date: 2007-05-20 14:01:34
Message-ID: 20070520140134.GE5855@piware.de (view raw or flat)
Thread:
Lists: pgsql-bugs
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 <wizzardx(at)gmail(dot)com> -----

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 <wizzardx(at)gmail(dot)com>, 425125(at)bugs(dot)debian(dot)org
Date: Sat, 19 May 2007 12:10:18 +0200
From: David <wizzardx(at)gmail(dot)com>
To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)org>

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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-05-20 17:45:55
Subject: Re: Fwd: Bug#425125: postgresql-8.1: localhost does not work for unix sockets in ~/.pgpass
Previous:From: JasonDate: 2007-05-20 13:30:53
Subject: BUG #3294: PostgreSQL Setting permissions for folders during installation then Crashing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group