From: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Broken after upgrade |
Date: | 2016-07-06 21:13:40 |
Message-ID: | CAK1hC9vp7_-adMtzBjiiHN3wz9j7b_C069VX8yv+Lu6ywgB9=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 6, 2016 at 8:56 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 7/6/2016 11:27 AM, Adrian Klaver wrote:
>>
>>
>> First, if possible copy your data dir and conf files somewhere for safety.
>
>
> +1 !!! must be first step.
It is the first thing I did
>
>>
>> From the looks of it Fedora upgraded your Postgres from 9.4.x to 9.5.3.
>> That constitutes a major upgrade and as the error says the data directory is
>> no longer compatible.
I can read here[0] on postgresql website that 9.5 have major enhancements.
>>
>> What Postgres versions are installed?
>>
>> Or did Fedora get rid of the Postgres 9.4 entirely?
Yes. I am only left with 9.5.3
>>
>> I do not use Fedora so I cannot get any more specific but this might help(
>> I would still backup up your data directory manually, even if the
>> instructions below say that is done for you):
>>
>> https://fedoraproject.org/wiki/PostgreSQL
>>
>> in particular:
>>
>> https://fedoraproject.org/wiki/PostgreSQL#Upgrade
>
>
> pretty much whatever you do, you'll need to install the 9.4 database server
> software temporarily in a separate directory, and you'll need to do the
> upgrade.
So the idea is to downgrade first to 9.4.8 ? I will try this way
>
> if your data is reasonable sized (say, under a few dozen gigabytes?), the
> easiest upgrade is to fire up both servers (configure that 9.4 to use a
> different port, like 5434), where 9.4 is running with your existing data
> directory, and 9.5 is running a freshly initdb'd empty database cluster,
> then do something like pg_dumpall -p 5434 | psql -p 5432
My data are small hopefully.
>
> if the data is larger, that could take a really long time, so you'll want to
> do a pg_upgrade, again with 9.4 configured for the existing database, and
> 9.5 running on an empty new cluster, then follow the pg_upgrade instructions
> on the website links above. this goes much faster if both 'data'
> directories are on the same file system, and you use the 'links' option...
>
>
[0]https://www.postgresql.org/docs/9.5/static/release-9-5.html
--
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-07-06 21:15:01 | Re: Fastest memmove in C |
Previous Message | Sylvain Marechal | 2016-07-06 20:00:05 | Re: Replication with non-read-only standby. |