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
