Ok, I have two versions of postgres installed and I don't know (remember) why. As I have nothing on the 9.4 one I don't have to care about the update. That's a bit of a relief. Sorry for the noise.
Mickaël 2014-10-14 21:11 GMT+02:00 LEDUQUE Mickaël <mledu...@gmail.com>: > Should I have a result like this one ? > > Ver Cluster Port Status Owner Data directory Log file > 9.3 main 5432 down postgres /var/lib/postgresql/9.3/main > /var/log/postgresql/postgresql-9.3-main.log > 9.4 main 5433 down postgres /var/lib/postgresql/9.4/main > /var/log/postgresql/postgresql-9.4-main.log > > 2014-10-14 20:07 GMT+02:00 Christoph Berg <m...@debian.org>: >> Re: LEDUQUE Mickaël 2014-10-14 >> <camfpoao23dskgzs0nbyhsnmyx8tygk9picmaa-18r5zbpyd...@mail.gmail.com> >>> > The on-disk format of the PostgreSQL 9.4 data files has changed between >>> > beta2 and beta3 (and as a consequence, the catalog version number). For >>> > that >>> > reason, existing PostgreSQL 9.4 clusters need to be dumped using the old >>> > package version, and reloaded after upgrading the packages. >>> > >>> > The postgresql-9.4 package will refuse to upgrade if any version 9.4 >>> > clusters exist on the system. >>> > >>> > To resolve the situation, before upgrading, execute: >>> > # su - postgres >>> > $ pg_lsclusters >>> > $ pg_ctlcluster 9.4 main start >>> > $ pg_dumpall --cluster 9.4/main | gzip > 9.4-main.dump.gz >>> > $ cp -a /etc/postgresql/9.4/main 9.4-main.config >>> > $ pg_dropcluster 9.4 main --stop >>> > >>> > Then after the upgrade, execute: >>> > # su - postgres >>> > $ pg_createcluster 9.4 main >>> > $ cp 9.4-main.config/* /etc/postgresql/9.4/main >>> > $ pg_ctlcluster 9.4 main start >>> > $ zcat 9.4-main.dump.gz | psql -q >>> > $ rm -rf 9.4-main.config 9.4-main.dump.gz >>> > >>> > If you have other clusters besides the default "main", repeat the above >>> > steps appropriately. >>> >>> Hi, >>> >>> Maybe what's missing is a way to find if one has 'other clusters >>> besides the default "main"'. >> >> That's why I put the pg_lsclusters call in there. But I guess people >> who have other clusters would know (it's not like the cluster could >> have been there for a decade and then been forgotten). >> >> I'll update the last paragraph to be more explicit about that part. >> >> Christoph >> -- >> c...@df7cb.de | http://www.df7cb.de/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
