Thread: BUG #14455: pg_upgrade fails with error

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ1NQpMb2dnZWQgYnk6ICAg
ICAgICAgIGsgegpFbWFpbCBhZGRyZXNzOiAgICAgIGt6aGVuZzFAZ21haWwu
Y29tClBvc3RncmVTUUwgdmVyc2lvbjogOS42LjEKT3BlcmF0aW5nIHN5c3Rl
bTogICBtYWMgT1Mgc2llcmEKRGVzY3JpcHRpb246ICAgICAgICAKClRyeWlu
ZyB0byBydW4gdGhlIGZvbGxvd2luZyBjb21tYW5kOg0KL3Vzci9sb2NhbC9D
ZWxsYXIvcG9zdGdyZXNxbC85LjYuMS9iaW4vcGdfdXBncmFkZSAtZCAvdXNy
L2xvY2FsL3Zhci9wb3N0Z3JlcwotRCAvdXNyL2xvY2FsL3Zhci9wb3N0Z3Jl
czkuNiAtYiAvdXNyL2xvY2FsL0NlbGxhci9wb3N0Z3Jlc3FsLzkuNS40XzEv
YmluIC1CCi91c3IvbG9jYWwvQ2VsbGFyL3Bvc3RncmVzcWwvOS42LjEvYmlu
IC12DQoNCkdvdCB0aGUgZXJyb3IgaW4gcGdfdXBncmFkZV9zZXJ2ZXIubG9n
DQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgcGdfdXBncmFkZSBydW4gb24g
V2VkIERlYyAgNyAyMjozMTozNyAyMDE2DQotLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LQ0KDQpjb21tYW5kOiAiL3Vzci9sb2NhbC9DZWxsYXIvcG9zdGdyZXNxbC85
LjUuNF8xL2Jpbi9wZ19jdGwiIC13IC1sCiJwZ191cGdyYWRlX3NlcnZlci5s
b2ciIC1EICIvdXNyL2xvY2FsL3Zhci9wb3N0Z3JlcyIgLW8gIi1wIDUwNDMy
IC1iICAtYwpsaXN0ZW5fYWRkcmVzc2VzPScnIC1jIHVuaXhfc29ja2V0X3Bl
cm1pc3Npb25zPTA3MDAgLWMKdW5peF9zb2NrZXRfZGlyZWN0b3JpZXM9Jy91
c3IvbG9jYWwvQ2VsbGFyL3Bvc3RncmVzcWwvOS42LjEvYmluJyIgc3RhcnQg
Pj4KInBnX3VwZ3JhZGVfc2VydmVyLmxvZyIgMj4mMQ0Kd2FpdGluZyBmb3Ig
c2VydmVyIHRvIHN0YXJ0Li4uLkZBVEFMOiAgWFgwMDA6IGNvdWxkIG5vdCBs
b2FkIGxpYnJhcnkKIi91c3IvbG9jYWwvbGliL3Bvc3RncmVzcWwvcGdfc3Rh
dF9zdGF0ZW1lbnRzLnNvIjoKZGxvcGVuKC91c3IvbG9jYWwvbGliL3Bvc3Rn
cmVzcWwvcGdfc3RhdF9zdGF0ZW1lbnRzLnNvLCAxMCk6IFN5bWJvbCBub3QK
Zm91bmQ6IF9HZXROYW1lZExXTG9ja1RyYW5jaGUNCiAgICAgICAgICBSZWZl
cmVuY2VkIGZyb206IC91c3IvbG9jYWwvbGliL3Bvc3RncmVzcWwvcGdfc3Rh
dF9zdGF0ZW1lbnRzLnNvDQogICAgICAgICAgRXhwZWN0ZWQgaW46IC91c3Iv
bG9jYWwvQ2VsbGFyL3Bvc3RncmVzcWwvOS41LjRfMS9iaW4vcG9zdGdyZXMN
CiAgICAgICAgIGluIC91c3IvbG9jYWwvbGliL3Bvc3RncmVzcWwvcGdfc3Rh
dF9zdGF0ZW1lbnRzLnNvDQpMT0NBVElPTjogIGludGVybmFsX2xvYWRfbGli
cmFyeSwgZGZtZ3IuYzoyMzUNCiBzdG9wcGVkIHdhaXRpbmcNCnBnX2N0bDog
Y291bGQgbm90IHN0YXJ0IHNlcnZlcg0KRXhhbWluZSB0aGUgbG9nIG91dHB1
dC4NCgoK

kzheng1@gmail.com writes:
> 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

You're trying to load a 9.6 version of pg_stat_statements.so into a 9.5
server.  That's not going to work.  (The error message isn't too
transparent, agreed, but we have no real control over that :-(.)

I'd venture that the problem is that you've tried to use /usr/local/lib/
rather than a version-specific library directory for this extension.
It'd be smart to rethink that.  In the short run you might be able to
work around it by turning off pg_stat_statements in the config for the
old server.

            regards, tom lane