From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | kzheng1(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14455: pg_upgrade fails with error |
Date: | 2016-12-08 04:54:51 |
Message-ID: | 15560.1481172891@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
kzheng1(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | daniele.varrazzo | 2016-12-08 19:16:42 | BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension |
Previous Message | kzheng1 | 2016-12-08 03:32:02 | BUG #14455: pg_upgrade fails with error |