[Pkg-postgresql-public] Bug#678626: php5-pgsql: can't connect to PostgreSQL 9.x

[Cédric Villemain]

Le samedi 23 juin 2012 12:19:26, Vincent Bernat a écrit :
> Package: php5-pgsql
> Version: 5.4.4-2
> Severity: important
> 
> Hi!
> 
> PostgreSQL 9.x in Debian now defaults to port 5433 (in postgresql.conf:
> port = 5433). php5-pgsql still defaults to 5432. An application that
> does not specify port won't be allowed to connect to a PostgreSQL
> database.

If you had a previous version of PostgreSQL installed and then install the new 
one, the port number is incremented so you can run both simultaneously.

For ex:
$ pg_lsclusters 
Version Cluster   Port Status Owner    Data directory                     Log 
file
9.0     main      5433 online postgres /var/lib/postgresql/9.0/main       
/var/log/postgresql/postgresql-9.0-main.log
9.1     main      5432 online postgres /var/lib/postgresql/9.1/main       
/var/log/postgresql/postgresql-9.1-main.log

PostgreSQL itself still defaults to 5432.

I don't know how pg_upgradecluster handle the case, if you used it.

> I don't know if this should be fixed in php5-pgsql or if the bug lies in
> PostgreSQL itself. Before 9.x, we were able to use SSL on port 5432
> without any problem. Feel free to relocate the bug to src:postgresql-9.1
> if needed.
> 
> I have put PostgreSQL maintainers in copy of this report.
> 
> -- System Information:
> Debian Release: wheezy/sid
>   APT prefers unstable
>   APT policy: (500, 'unstable'), (500, 'testing'), (101, 'experimental')
> Architecture: amd64 (x86_64)
> Foreign Architectures: i386
> 
> Kernel: Linux 3.2.0-2-amd64 (SMP w/2 CPU cores)
> Locale: LANG=fr_FR.utf8, LC_CTYPE=fr_FR.utf8 (charmap=UTF-8)
> Shell: /bin/sh linked to /bin/dash
> 
> Versions of packages php5-pgsql depends on:
> ii  dpkg                                   1.16.4.3
> ii  libapache2-mod-php5 [phpapi-20100525]  5.4.4-2
> ii  libc6                                  2.13-33
> ii  libpq5                                 9.1.4-2
> ii  php5-cgi [phpapi-20100525]             5.4.4-2
> ii  php5-cli [phpapi-20100525]             5.4.4-2
> ii  php5-common                            5.4.4-2
> ii  ucf                                    3.0025+nmu3
> 
> php5-pgsql recommends no packages.
> 
> php5-pgsql suggests no packages.
> 
> -- no debconf information

-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20120623/c2b20129/attachment.pgp>