pg_upgrade 9.5.1: pg_upgrade_support missing

On 03/02/2016 01:42 AM, schoetbi schoetbi wrote:

Hello,

i tried to migrate a database cluster from pg 9.4.1 to 9.5.1 with
pg_upgrade. I got the follwing error:

c:\Temp>"C:\Program Files\PostgreSQL\9.5\bin\pg_upgrade" -b
"C:\Program Files\PostgreSQL\9.4\bin" -B "C:\Program
Files\PostgreSQL\9.5\bin" -
d "C:\Program Files\PostgreSQL\9.4\data" -D "C:\Program
Files\PostgreSQL\9.5\data" -p 5433 -P 5432 -U postgres
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for reg* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
ok
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing
from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt
Failure, exiting

The file loadable_libraries.txt contains:

Could not load library "$libdir/pg_upgrade_support"
FEHLER: konnte nicht auf Datei „$libdir/pg_upgrade_support“
zugreifen: No such file or directory

I tried to copy the dll from the 9.4 version but the interface seems not
to be compatible.

I use postgres under Windows 7 64 Bit.

So how did you install Postgres(and from where) and was it different for
9.4 versus 9.5?

Note: This is a question first asked here:
https://www.pg-forum.de/viewtopic.php?f=54&t=7495

Thanks,
Tobias

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

schoetbi schoetbi <tobias.schoenit@gmail.com> writes:

i tried to migrate a database cluster from pg 9.4.1 to 9.5.1 with
pg_upgrade. I got the follwing error:

Could not load library "$libdir/pg_upgrade_support"

Hmm, pg_upgrade_support isn't a separate library anymore; it's been merged
into core. I would not have expected that to cause any problems, because
the functions in that library shouldn't have been referenced in your old
database in the first place. They were supposed to be installed and then
removed again during the process of (prior versions of) pg_upgrade.

I'm guessing you had leftovers from old failed pg_upgrade attempts that
you never completed.

What you want to do is simply manually drop the functions referencing
$libdir/pg_upgrade_support. A look into the pg_upgrade sources suggests
that this ought to do it:

DROP SCHEMA IF EXISTS binary_upgrade CASCADE;

though you'll probably have to do that in every database of the
installation.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Hello,

I tried to delete all binary_upgrade schematas using this:

$ psql -tc "SELECT datname FROM pg_database" -U postgres -p 5433 | xargs -I
{} psql -d {} -U postgres -p 5433 -tc "drop schema if exists binary_upgrade
cascade;"

But got this:
output is not a tty

So I got the dblist from pgadmin and saved to file:
That worked:
$ cat dblist.txt | xargs -I {} psql -d {} -U postgres -p 5433 -tc "drop
schema if exists binary_upgrade cascade;"

pg_upgrade succeeded with the step:
Checking for presence of required libraries ok

But then I got:
Checking database user is the install user
Only the install user can be defined in the new cluster.
Failure, exiting

But this is the next story ;-) I can assure that deleting the schematas from
the source db solves my initial problem.

Thanks for your help,
Tobias Schönit

--
View this message in context: http://postgresql.nabble.com/pg-upgrade-9-5-1-pg-upgrade-support-missing-tp5890202p5890380.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general