Search Postgresql Archives

Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/23/19 7:17 AM, Perumal Raj wrote:
Hi Luca

-bash-4.2$ "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
-bash-4.2$

-bash-4.2$ pwd
/var/lib/pgsql
-bash-4.2$

upgrade log :


command: "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1 waiting for server to start....FATAL:  unrecognized configuration parameter "unix_socket_directory"

Well unix_socket_directory changed to  unix_socket_directories in 9.3.

Are you sure that /usr/pgsql-9.2/bin/pg_ctl is really pointing to a 9.2 binary?

  stopped waiting
pg_ctl: could not start server
Examine the log output.


On Tue, Jul 23, 2019 at 7:15 AM Luca Ferrari <fluca1978@xxxxxxxxx <mailto:fluca1978@xxxxxxxxx>> wrote:

    On Tue, Jul 23, 2019 at 3:56 PM Perumal Raj <perucinci@xxxxxxxxx
    <mailto:perucinci@xxxxxxxxx>> wrote:
     > could not connect to source postmaster started with the command:
     > "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
    "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c
    unix_socket_permissions=0700 -c
    unix_socket_directory='/var/lib/pgsql'" start
     > Failure, exiting

    Is /var/lib/pgsql directory on the system?
    Can you start the instance with the above command?


    Luca



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux