[Bug 240645] database/postgresql* : upgrading postgres fails when database(s) uses postgis extension

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=240645

            Bug ID: 240645
           Summary: database/postgresql* : upgrading postgres fails when
                    database(s) uses postgis extension
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs at FreeBSD.org
          Reporter: smars at yuntech.edu.tw

The line (20190829) in /usr/ports/UPDATING instructing how to convert database
to the newest version fails when databases to convert use the postgis
extension:

--> /usr/ports/UPDATING
---
su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d
/usr/local/pgsql/data/ -B /us      r/local/bin/ -D /var/db/postgres/data11/ -U
pgsql "
---

It is a version incompatibility problem of databases/postgis* (new version is
2.5, previous version 2.4):

-> /var/log/messages:
----
"could not access file "$libdir/postgis-2.4": No such file or directory"
----

I tried:
1. to create a simlink (no effect)
2. to install the previous version of postgis in /tmp/pg-upgrade (to do
something similar as what is proposed in UPDATING)
-> /var/log/messages:
----
ERROR:  incompatible library
"/tmp/pg-upgrade/usr/local/lib/postgresql/postgis-2.4.so": version mismatch
Sep 17 21:39:40 <local0.warn> * postgres[5237]: [3-2] DETAIL:  Server is
version 9.5, library is version 9.4.
----

Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.