On 07/11/2016 01:00 AM, arnaud gaboury wrote:
On Sun, Jul 10, 2016 at 7:07 PM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx> wrote:
On 07/10/2016 03:13 AM, arnaud gaboury wrote:
My box upgraded postgresql from 9.4.8 to 9.5.3 when doing a full
version upgrade (Fedora 23 --> 24).
I have now :
/db/pgsal/data ----> initialized with 9.5, with postgresql.conf and
pg_hab.conf from 9.4
/db/pgsql/data.old ----> the old one from 9.4
Which is the opposite of what you said here:
https://www.postgresql.org/message-id/CAK1hC9t6h9CENXQ6FHchx1Ny1AAAuYf2ARTpeospz1Jd7q_qLg%40mail.gmail.com
How can I start postgres with socket location in /db/pgsql ? There is
no option in pg_ctl to indicate socket directory.?
Thank you for help
At this point I think your best option is to start over, if that is
possible. By this I mean:
1) See if it is possible to get a Fedora 24 package from Fedora for Postgres
9.4.
2) If it is make sure you have the existing 9.4 cluster saved somewhere out
of the way.
3) Uninstall Postgres 9.5
4) Install Postgres 9.4 and copy the cluster you saved 2) into the data
directory.
5) Decide whether you want to stay with 9.4 or move up to 9.5.
6) If you do decide to move up take a pg_dump of the 9.4 data before you do
anything.
I already wasted too much time on this issue. I had one back up of my
/db/pgsql/data folder. I know this folder is clean and was the one I
used with 9.4. Now, using this folder, none of the described methods
work.
I decided to initialize a new DB and create again the database, as
this one was luckily small.
Now everything is OK and I will act differently on the next major
version upgrade.
To make things easier and to echo Kris Deugau's suggestion I would use
the community repos:
https://www.postgresql.org/download/linux/redhat/#yum
Thank you for your patience.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
