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