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
