Re: pg_upgrade fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Artem Tomyuk <admin(at)leboutique(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_upgrade fails
Date: 2015-11-05 15:58:23
Message-ID: 7863.1446739103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Artem Tomyuk <admin(at)leboutique(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Falcão Vianna 2015-11-05 16:59:09 [Incremental Backup]Restore pg_basebackup and WAL files
Previous Message Keith 2015-11-05 15:52:11 Re: pg_upgrade fails