Date: Tue, 17 Sep 2019 14:07:22 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 240645] database/postgresql* : upgrading postgres fails when database(s) uses postgis extension Message-ID: <bug-240645-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D240645 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@FreeBSD.org Reporter: smars@yuntech.edu.tw The line (20190829) in /usr/ports/UPDATING instructing how to convert datab= ase 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! --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-240645-7788>