BUG #14455: pg_upgrade fails with error

From: kzheng1(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14455: pg_upgrade fails with error
Date: 2016-12-08 03:32:02
Message-ID: 20161208033202.31177.49803@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14455
Logged by: k z
Email address: kzheng1(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: mac OS siera
Description:

Trying to run the following command:
/usr/local/Cellar/postgresql/9.6.1/bin/pg_upgrade -d /usr/local/var/postgres
-D /usr/local/var/postgres9.6 -b /usr/local/Cellar/postgresql/9.5.4_1/bin -B
/usr/local/Cellar/postgresql/9.6.1/bin -v

Got the error in pg_upgrade_server.log

----------------------------------------------------------------
pg_upgrade run on Wed Dec 7 22:31:37 2016
-----------------------------------------------------------------

command: "/usr/local/Cellar/postgresql/9.5.4_1/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/usr/local/var/postgres" -o "-p 50432 -b -c
listen_addresses='' -c unix_socket_permissions=0700 -c
unix_socket_directories='/usr/local/Cellar/postgresql/9.6.1/bin'" start >>
"pg_upgrade_server.log" 2>&1
waiting for server to start....FATAL: XX000: could not load library
"/usr/local/lib/postgresql/pg_stat_statements.so":
dlopen(/usr/local/lib/postgresql/pg_stat_statements.so, 10): Symbol not
found: _GetNamedLWLockTranche
Referenced from: /usr/local/lib/postgresql/pg_stat_statements.so
Expected in: /usr/local/Cellar/postgresql/9.5.4_1/bin/postgres
in /usr/local/lib/postgresql/pg_stat_statements.so
LOCATION: internal_load_library, dfmgr.c:235
stopped waiting
pg_ctl: could not start server
Examine the log output.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-12-08 04:54:51 Re: BUG #14455: pg_upgrade fails with error
Previous Message Pavel Stehule 2016-12-07 16:01:28 Re: BUG #14454: xmlelement doesn't support encoding