Re: Broken after upgrade

On 07/09/2016 11:06 AM, arnaud gaboury wrote:
> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com