Re: Broken after upgrade - Mailing list pgsql-general

On Sat, Jul 9, 2016 at 8:45 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> On 07/09/2016 11:40 AM, arnaud gaboury wrote:
>>
>> On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver <adrian.klaver@aklaver.com>
>> wrote:
>>>
>>> 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?
>>
>> NO
>>>
>>>
>>> Just trying to figure out where the 9.4 binaries are coming from?
>>
>> postgresql-update Fedora package
>>
>>
>>>
>>>>
>>>>>
>>>>>
>>>>> 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
>>
>>
>> I changed the name to 9-4 et 9-5 for convenience
>
>
> Please don't do that, it just adds to the confusion. For instance I still do
> not know what data-* maps to /db/pgsql/data*.
>
> So please run the cat on the actual directories.

Here is my /db/pgsql :

data-9.4 (formerly data)
data-9.5 (formerly 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
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



--

google.com/+arnaudgabourygabx