error when upgrading 9.4 to 9.5 manually

From: arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: error when upgrading 9.4 to 9.5 manually
Date: 2016-07-10 10:13:47
Message-ID: CAK1hC9vVFXcj43MPM3BAuKVZed-SG85DSa=UxMam4xG+e1d_5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

/usr/lib64/pgsql/postgresql-9.4/bin which comes from
postgresql-upgrade Fedora package.
$ ls /usr/lib64/pgsql/postgresql-9.4/bin
drwxr-xr-x 1 root root 22 Jul 7 09:21 ../
-rwxr-xr-x 1 root root 28K May 12 15:34 pg_controldata*
-rwxr-xr-x 1 root root 41K May 12 15:34 pg_ctl*
-rwxr-xr-x 1 root root 29K May 12 15:34 pg_isready*
-rwxr-xr-x 1 root root 45K May 12 15:34 pg_receivexlog*
-rwxr-xr-x 1 root root 49K May 12 15:34 pg_recvlogical*
-rwxr-xr-x 1 root root 36K May 12 15:34 pg_resetxlog*
-rwxr-xr-x 1 root root 5.8M May 12 15:34 postgres*
lrwxrwxrwx 1 root root 8 May 12 15:33 postmaster -> postgres*

Now I think I shall run this command with postgres off
:

$ pg_upgrade -b /usr/lib64/pgsql/postgresql-9.4/bin -B /usr/bin -d
/db/pgsql/data.old -D /db/pgsql/data
But it reurns this error:

connection to database failed: could not connect to server: No such
file or directory
Is the server running locally and accepting
connections on Unix domain socket "/db/pgsql/.s.PGSQL.50432"?

could not connect to old postmaster started with the command:
"/usr/lib64/pgsql/postgresql-9.4/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/db/pgsql/data.old" -o "-p 50432 -b -c
listen_addresses='' -c unix_socket_permissions=0700 -c
unix_socket_directories='/db/pgsql'" start
--------------------------------------

Posgresql is started with systemd service file and its socket is in
/run/postgresql

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

--

google.com/+arnaudgabourygabx

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-07-10 15:36:23 Re: error when upgrading 9.4 to 9.5 manually
Previous Message Adrian Klaver 2016-07-09 20:30:23 Re: Broken after upgrade