> 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"'. Mickaël -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
