[Pkg-postgresql-public] Bug#764705: Bug#764705: Bug#764705: Bug#764705: Bug#764705: Bug#764705: postgresql-9.4: ERROR: The database format changed between beta 2 and 3. Please dump, but how?

[LEDUQUE Mickaël]

>   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