[Pkg-postgresql-public] Bug#764705: 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?

[Christoph Berg]

Re: LEDUQUE Mickaël 2014-10-14 <CAMFPOao23DSKgzs0nByHsNMyX8TYgk9PicmaA-18R5ZbpyDS4Q at 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
-- 
cb at df7cb.de | http://www.df7cb.de/