[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?

[LEDUQUE Mickaël]

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 <myon at debian.org>:
> 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/