Arch Linux

bigblondewolf

Member

Registered: 2013-09-14

Posts: 11

pg_upgrade fails for "$libdir/postgis-2.0"

Hello

I was trying to update my system, when found that postgresql needs a little tweaking from 9.2 to 9.3. Following the instructions on the wiki, I ran pg_upgrade:

[26] root@xxxlinux : /home/ognyan $  su - postgres -c 'pg_upgrade -b /opt/pgsql-9.2/bin/ -B /usr/bin/ -d /var/lib/postgres/data-9.2 -D /var/lib/postgres/data'
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Checking database user is a superuser                       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

As mentioned on the wiki, postgis-2.0.so was missing:

[27] root@xxxlinux : /home/ognyan $ cat /var/lib/postgres/loadable_libraries.txt
Could not load library "$libdir/postgis-2.0"
ERROR:  could not access file "$libdir/postgis-2.0": No such file or directory

I unpacked the postgis-2.0.so from the old package. In fact it is in postgis-2.0, not postgresql-9.2, as the wiki says. I copied the file to /opt/pgsql-9.2/lib, but there was no effect. I even created several links to see if I got the filename wrong:

[28] root@xxxlinux : /home/ognyan $ ll /opt/pgsql-9.2/lib/postgis*
lrwxrwxrwx 1 postgres postgres   14 Nov  8 01:17 /opt/pgsql-9.2/lib/postgis -> postgis-2.0.so
lrwxrwxrwx 1 postgres postgres   14 Nov  8 01:17 /opt/pgsql-9.2/lib/postgis-2.0 -> postgis-2.0.so
-rwxr-xr-x 1 postgres postgres 623K Nov  8 00:36 /opt/pgsql-9.2/lib/postgis-2.0.so
lrwxrwxrwx 1 postgres postgres   14 Nov  8 01:17 /opt/pgsql-9.2/lib/postgis.so -> postgis-2.0.so

I tried an strace:

su - postgres -c 'strace -o /tmp/strace.postgres.log pg_upgrade -b /opt/pgsql-9.2/bin/ -B /usr/bin/ -d /var/lib/postgres/data-9.2 -D /var/lib/postgres/data'

The strace.postgres.log did not show anything relevant to postgis-2.0 except logging that it failed.

Packages currently installed:

[48] root@xxxlinux : /home/ognyan $ pacman -Q postgresql postgresql-old-upgrade postgis
postgresql 9.3.1-3
postgresql-old-upgrade 9.2.5-1
postgis 2.1.0-2

Is there something I am still missing or overlooking, any cache needs refreshing? pg_upgrade keeps failing, even with the library in place.