From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Broken after upgrade |
Date: | 2016-07-09 18:22:08 |
Message-ID: | e8c93802-2841-e820-32b3-0a6cc385646a@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/09/2016 11:06 AM, arnaud gaboury wrote:
> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>> On 07/09/2016 08:08 AM, arnaud gaboury wrote:
>>>
>>> I understand you are confused, as I am too and tried too many things
>>> with no success.
>>>
>>> I have postgresql 9.5.3 installed, and the upgrade was from 9.4.8 to
>>> 9.5.3.
>>> I can find in /usr/lib64/pgsql/postgresql-9.4 some binaries from
>>> previous versions. Nothing in /opt/ as it can be sometimes indicated.
>>>
>>> I have my old database in /db/pgsql/data.old and the new empty
>>> initialized with 9.5 in /db/pgsql/data.old (here versions are given by
>>> PG_VERSION files).
>>
>>
>> The above does not make sense, they both cannot be in the same data
>> directory. So to repeat, please answer each of the below after the question
>> and in detail eg. showing the actual commands you ran and the results:
>>
>>
>>
>>
>> 2) What versions of Postgres do you have installed and/or running?
> % dnf info postgresql
> Last metadata expiration check: 2 days, 20:46:44 ago on Wed Jul 6
> 23:17:54 2016.
> Installed Packages
> Name : postgresql
> Arch : x86_64
> Epoch : 0
> Version : 9.5.3
> Release : 1.fc24
Have you installed Postgres from some other source then the package manager?
Just trying to figure out where the 9.4 binaries are coming from?
>
>>
>>
>> 3) List what is in the PG_VERSION file of each directory you are using.
> % cat data-9.4/PG_VERSION
> 9.4
> % cat data-9.5/PG_VERSION
> 9.5
So where are you getting the below directories from?:
/db/pgsql/data
/db/pgsql/data.old
>
>>>>
>>>> 1) Did you run the Fedora postgresql-setup upgrade command at any time?
> YES
>
>
>>>
>>> Yes I did many times against a /db/pgsql/data with my 9.4 database (If
>>> I run the command with the 9.5 initialized data folder, I get ERROR:
>>> Cannot upgrade because the database in /db/pgsql/data is of
>>> version 9.5 but it should be 9.4).
>>
>>
>>>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2016-07-09 18:40:56 | Re: Broken after upgrade |
Previous Message | arnaud gaboury | 2016-07-09 18:06:30 | Re: Broken after upgrade |