pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade fails
3+ messages / 3 participants
[nested] [flat]
* pg_upgrade fails
@ 2015-11-05 15:42 Artem Tomyuk <admin@leboutique.com>
0 siblings, 2 replies; 3+ messages in thread
From: Artem Tomyuk @ 2015-11-05 15:42 UTC (permalink / raw)
To: pgsql-admin
Hi.
Trying to upgrade from 9.1 to 9.4
Upgrade fails with error:
Could not load library "$libdir/dblink"
ERROR: could not load library "/usr/pgsql-9.4/lib/dblink.so":
/usr/pgsql-9.4/lib/dblink.so: undefined symbol: PQsetSingleRowMode
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgrade fails
@ 2015-11-05 15:52 Keith <keith@keithf4.com>
parent: Artem Tomyuk <admin@leboutique.com>
1 sibling, 0 replies; 3+ messages in thread
From: Keith @ 2015-11-05 15:52 UTC (permalink / raw)
To: Artem Tomyuk <admin@leboutique.com>; +Cc: pgsql-admin
On Thu, Nov 5, 2015 at 10:42 AM, Artem Tomyuk <admin@leboutique.com> wrote:
> Hi.
> Trying to upgrade from 9.1 to 9.4
> Upgrade fails with error:
>
> Could not load library "$libdir/dblink"
>
> ERROR: could not load library "/usr/pgsql-9.4/lib/dblink.so":
> /usr/pgsql-9.4/lib/dblink.so: undefined symbol: PQsetSingleRowMode
>
>
> Make sure you have the contrib package for 9.4 installed.
Keith
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgrade fails
@ 2015-11-05 15:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: Artem Tomyuk <admin@leboutique.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2015-11-05 15:58 UTC (permalink / raw)
To: Artem Tomyuk <admin@leboutique.com>; +Cc: pgsql-admin
Artem Tomyuk <admin@leboutique.com> writes:
> Trying to upgrade from 9.1 to 9.4
> Upgrade fails with error:
> Could not load library "$libdir/dblink"
> ERROR: could not load library "/usr/pgsql-9.4/lib/dblink.so":
> /usr/pgsql-9.4/lib/dblink.so: undefined symbol: PQsetSingleRowMode
dblink.so is apparently trying to link to the 9.1 version of libpq.so,
which lacks some functions that exist in 9.4. You probably need to
install the 9.4 libpq.so library first (it should work with 9.1 callers,
unlike vice versa).
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-11-05 15:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-11-05 15:42 pg_upgrade fails Artem Tomyuk <admin@leboutique.com>
2015-11-05 15:52 ` Keith <keith@keithf4.com>
2015-11-05 15:58 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox