Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[ADMIN] pg_upgrade fails

10 views
Skip to first unread message

Artem Tomyuk

unread,
Nov 5, 2015, 10:45:01 AM11/5/15
to
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


Keith

unread,
Nov 5, 2015, 10:54:42 AM11/5/15
to
Make sure you have the contrib package for 9.4 installed.

Keith

Tom Lane

unread,
Nov 5, 2015, 11:00:25 AM11/5/15
to
Artem Tomyuk <ad...@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...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

sail...@gmail.com

unread,
Mar 9, 2017, 6:45:04 AM3/9/17
to
Hi,

Getting wrong number of rows from PQcmdTuples after executing PQsendQueryParams.Any idea?
0 new messages