On Sat, Jul 9, 2016 at 8:45 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > On 07/09/2016 11:40 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> >> wrote: >>> >>> On 07/09/2016 11:06 AM, arnaud gaboury wrote: >>>> >>>> >>>> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver >>>> <adrian.klaver@xxxxxxxxxxx> >>>> 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@xxxxxxxxxxx >> >> >> >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx -- google.com/+arnaudgabourygabx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
