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
signature.asc
Description: This is a digitally signed message part.