Package: postgresql-client-common Version: 94lenny1 Severity: important Tags: confirmed
Hello Stan,
thanks for your report. I can reproduce it here, thinko in pg_wrapper.
This happens if there is more than one cluster on the machine, and
none runs on the default port 5432.
----- Forwarded message from Stan <s...@icsi.berkeley.edu> -----
X-Spam-Status: No, score=0.0 required=4.0 tests=BAYES_50 autolearn=no
version=3.2.3
Date: Wed, 18 Feb 2009 15:07:38 -0800
From: Stan <s...@icsi.berkeley.edu>
To: mp...@debian.org
Subject: strange new psql 8.3.5 behavior
Hi Martin,
Oddly, what used to work perfectly on these amd64 Lenny PG 8.3.5 boxes
and many older boxes -- being able to psql -h <socket-dir> -p <port> --
is all of a sudden broken. No known apt-get/aptitude upgrades were
recently run.
Newly broken:
> postg...@farnsworth:~$ ls -al /var/run/postgresql/emailmonitor
> total 8
> drwxr-sr-x 2 postgres postgres 78 2009-02-18 14:28 .
> drwxrwsr-x 4 postgres postgres 35 2009-02-18 14:14 ..
> -rw------- 1 postgres postgres 6 2009-02-18 14:28 8.3-emailmonitor.pid
> srwxrwxrwx 1 postgres postgres 0 2009-02-18 14:28 .s.PGSQL.5434
> -rw------- 1 postgres postgres 43 2009-02-18 14:28 .s.PGSQL.5434.lock
> postg...@farnsworth:~$ psql -h /var/run/postgresql/emailmonitor -p 5434
> Error: No existing local cluster is suitable as a default target. Please see
> man pg_wrapper(1) how to specify one.
> postg...@farnsworth:~$ pg_lsclusters
> Version Cluster Port Status Owner Data directory Log
> file
> 8.3 emailmonitor 5434 online postgres
> /var/lib/postgresql/8.3/emailmonitor
> /var/log/postgresql/postgresql-8.3-emailmonitor.log
> 8.3 jms 5433 online postgres /var/lib/postgresql/8.3/jms
> /var/log/postgresql/postgresql-8.3-jms.log
This works though:
> postg...@farnsworth:~$ psql --cluster 8.3/emailmonitor
> Welcome to psql 8.3.5, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> postgres=# \q
The packages on this Lenny amd64 box:
> postg...@farnsworth:~$ dpkg-query -l | grep -i postg
> ii libpq5 8.3.5-1 PostgreSQL C
> client library
> ii pgfouine 1.0-1.2 PostgreSQL log
> analyzer
> ii postgresql 8.3.5-1
> object-relational SQL database (supported version)
> ii postgresql-8.3 8.3.5-1
> object-relational SQL database, version 8.3 server
> ii postgresql-client-8.3 8.3.5-1 front-end
> programs for PostgreSQL 8.3
> ii postgresql-client-common 94 manager for
> multiple PostgreSQL client versions
> ii postgresql-common 94 PostgreSQL
> database-cluster manager
> ii postgresql-contrib 8.3.5-1 additional
> facilities for PostgreSQL (supported version)
> ii postgresql-contrib-8.3 8.3.5-1 additional
> facilities for PostgreSQL
Any thoughts would be appreciated.
Cheers,
Stan
----- End forwarded message -----
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
