[php-maint] Bug#385077: php5-pgsql: Will not connect to PostgreSQL 8.1

Tyler Riddle tyler at tylerriddle.com
Mon Aug 28 21:16:41 UTC 2006

Package: php5-pgsql
Version: 5.1.4-0.1
Severity: grave
Justification: renders package unusable

The package will not connect to PostgreSQL 8.1; the connection fails 
with the following error:

Warning: pg_connect() [function.pg-connect]: Unable to connect to 
PostgreSQL server: could not connect to server: No such file or 
directory Is the server running locally and accepting connections on 
Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

However, PostgreSQL is running and listening for connections; the 
PostgreSQL utilities, such as psql, connect with out trouble. The 
contents of /var/run/postgresql is:

tyler at mom:/var/run/postgresql$ ls -a
..  ..  8.1-main.pid  .s.PGSQL.5433  .s.PGSQL.5433.lock
tyler at mom:/var/run/postgresql$ 

As you can see, the filenames differ by a single number (5432 vs 5433). 
However, this bug makes the package useless for connecting to version 
8.1 of PostgreSQL.

 System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.4.27-2-386
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages php5-pgsql depends on:
ii  debconf [debconf-2.0]        1.5.3       Debian configuration management sy
ii  libapache2-mod-php5 [phpapi- 5.1.4-0.1   server-side, HTML-embedded scripti
ii  libc6                        2.3.6.ds1-4 GNU C Library: Shared libraries
ii  libpq4                       8.1.4-6     PostgreSQL C client library
ii  php5-common                  5.1.4-0.1   Common files for packages built fr

php5-pgsql recommends no packages.

-- debconf information:
  php5/extension_pgsql_apache2: true
  php5/remove_extension: true
  php5/add_extension: true

More information about the pkg-php-maint mailing list