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

Ok, I have two versions of postgres installed and I don't know
(remember) why. As I have nothing on the 9.4 one I don't have to care
about the update. That's a bit of a relief. Sorry for the noise.

Mickaël

2014-10-14 21:11 GMT+02:00 LEDUQUE Mickaël <mleduque at gmail.com>:
> 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/