From owner-freebsd-ports-bugs@freebsd.org Tue Sep 17 14:07:22 2019 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id DB10112501C for ; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 46XlL25VySz43TP for ; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id BCF9D12501A; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) Delivered-To: ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id BCC5E125019 for ; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 46XlL24ZW6z43TN for ; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 819A797CC for ; Tue, 17 Sep 2019 14:07:22 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id x8HE7M2e090383 for ; Tue, 17 Sep 2019 14:07:22 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id x8HE7M12090382 for ports-bugs@FreeBSD.org; Tue, 17 Sep 2019 14:07:22 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 240645] database/postgresql* : upgrading postgres fails when database(s) uses postgis extension Date: Tue, 17 Sep 2019 14:07:22 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: smars@yuntech.edu.tw X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 17 Sep 2019 14:07:22 -0000 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 * 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.=