・OS:CentOS7.0.1406
・ディストリビューション:redhat
・PostgreSQL(old): 9.2.23
・PostgreSQL(new): 9.6.21
経緯: PostgreSQLを9.2.23から9.6.21にアップグレードしようとしています。
Pg_upgradeスクリプトを実行しましたところで
エラーになりました。
この後、どう対処していいかご教示いただけますようお願いいたします。
↓↓↓↓↓これはコンソール出力↓↓↓↓↓
/usr/local/pgsql9.6.21/bin/pg_upgrade -d /var/pgsql/data -D /var/pgsql/data9621 -b /usr/
local/pgsql/bin -B /usr/local/pgsql9.6.21/bin -U postgres
Performing Consistency Checks
Checking cluster versions ok
failure
Consult the last few lines of "pg_upgrade_server.log" for
the probable cause of the failure.
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 "/var/pgsql/.s.PGSQL.50432"?
could not connect to old postmaster started with the command:
"/usr/local/pgsql/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/pgsql/data" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/pgsql'" start
Failure, exiting:
↓↓↓↓↓ pg_upgrade_server.log の内容です ↓↓↓↓↓
pg_upgrade run on Sun Apr 18 14:25:48 2021
command: "/usr/local/pgsql/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/pgsql/data" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/pgsql'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....FATAL: unrecognized configuration parameter "unix_socket_directories"
stopped waiting
pg_ctl: could not start server
Examine the log output.
あなたの回答
tips
プレビュー