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