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

[Cédric Villemain]

Le samedi 23 juin 2012 13:02:58, Vincent Bernat a écrit :
>  ❦ 23 juin 2012 12:41 CEST, Cédric Villemain <cedric at 2ndquadrant.com> :
> >> 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.
> 
> [...]
> 
> > PostgreSQL itself still defaults to 5432.
> 
> Thanks for the tip!
> 
> My bug report is therefore invalid. This behaviour is a bit disturbing
> since 5433 is still used if the other version is removed afterwards (I
> usually remove the older version of PostgreSQL when I notice I have
> installed the new one) but I think there is no universal solution for
> this.

I suppose this pattern is frequent:

 1. install postgresql X.Y
 2. work
 3. install postgresql X.Y+1 (major release)
 4. upgrade
 5. check things
 6. remove old one

It might be good enough if pg_upgradecluster can change the port in 4. (new 
option, I believe) and/or have a special feature to upgrade configuration to 
recover the previous 'main' parameters (port,socket, listen_adress, ...) in 
step 6.
(this is ignoring the case where you have multiple clusters defined, but 'main' 
is usually the default one)

Anyway, those are new features suggestions. They need their own bug report if 
someone trust in them.
-- 
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/5d6810f7/attachment.pgp>