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
--
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 |