Content-Type: multipart/alternative;
 boundary="------------LsaVG01oXxFSByPiCwuy0PTU"
Message-ID: <0242964f-7cc2-4172-81ca-e05a7f8ee613@netcologne.de>
Date: Tue, 22 Aug 2023 14:03:42 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Compatibility postgis
Content-Language: en-US
References: <fc6e84d8-be8e-4cc1-b97c-59e26328effd@mailbox.org>
To: pgsql-admin@lists.postgresql.org
From: vrms <vrms@netcologne.de>
In-Reply-To: <fc6e84d8-be8e-4cc1-b97c-59e26328effd@mailbox.org>
Archived-At: 
 <https://www.postgresql.org/message-id/0242964f-7cc2-4172-81ca-e05a7f8ee613%40netcologne.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------LsaVG01oXxFSByPiCwuy0PTU
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


compatibility between postgres/GIS as well as upgrading is a little tricky.
This 
<https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS#PostGISSupportMatrix> 
is a good starting point to see what you have to aim for.

Next challenge is to figure out a workable upgrade path as it is not 
unlikely you will have to go through some intermediate steps.

Maybe it would help whether you can specify which PostGIS version you 
are coming from on the source (postgres-12) Installation.

On 22.08.23 09:35, Rajesh Kumar wrote:
> I am tring to upgrade from postgres 12 to postgres 15.
>
> And it seems like posigis extension I have on V12 is not compatible 
> with V15.
>
> I get following error
>
>
> command: "/usr/pgsql-15/bin/pg_dump" --host /var/lib/pgsql --port 
> 50432 --username postgres --schema-only --quote-all-identifiers 
> --binary-upgrade --format=cu stom 
> --file="/var/lib/pgsql/data/15/data/pg_upgrade_output.d/20230818T082920.083/dump/pg_upgrade_dump_27286.custom" 
> 'dbname=common' >> "/var/lib/pgsql/data/1 
> 5/data/pg_upgrade_output.d/20230818T082920.083/log/pg_upgrade_dump_27286.log" 
> 2>&1 pg_dump: error: query failed: ERROR: could not access file 
> "$libdir/postgis-3": No such file or directory
>
--------------LsaVG01oXxFSByPiCwuy0PTU
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <br>
    <div class="moz-forward-container">compatibility between
      postgres/GIS as well as upgrading is a little tricky. <br>
      <div class="moz-forward-container"> <a
href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS#PostGISSupportMatrix"
          moz-do-not-send="true">This</a> is a good starting point to
        see what you have to aim for.<br>
        <br>
        Next challenge is to figure out a workable upgrade path as it is
        not unlikely you will have to go through some intermediate
        steps.<br>
        <br>
        <div class="moz-cite-prefix">Maybe it would help whether you can
          specify which PostGIS version you are coming from on the
          source (postgres-12) Installation.<br>
          <br>
          On 22.08.23 09:35, Rajesh Kumar wrote:<br>
        </div>
        <blockquote type="cite"
cite="mid:CAJk5AtbuQv+p2rYgGLOZ4a=abhxVJz5AxAZn_o+s3Qe+4q3ksg@mail.gmail.com">
          <meta http-equiv="content-type"
            content="text/html; charset=UTF-8">
          <div dir="auto">I am tring to upgrade from postgres 12 to
            postgres 15.
            <div dir="auto"><br>
            </div>
            <div dir="auto">And it seems like posigis extension I have
              on V12 is not compatible with V15.</div>
            <div dir="auto"><br>
            </div>
            <div dir="auto">I get following error</div>
            <div dir="auto"><br>
            </div>
            <div dir="auto"><br>
              <div dir="auto">command: "/usr/pgsql-15/bin/pg_dump"
                --host /var/lib/pgsql --port 50432 --username postgres
                --schema-only --quote-all-identifiers --binary-upgrade
                --format=cu stom
--file="/var/lib/pgsql/data/15/data/pg_upgrade_output.d/20230818T082920.083/dump/pg_upgrade_dump_27286.custom"
                'dbname=common' &gt;&gt; "/var/lib/pgsql/data/1
5/data/pg_upgrade_output.d/20230818T082920.083/log/pg_upgrade_dump_27286.log"
                2&gt;&amp;1 pg_dump: error: query failed: ERROR: could
                not access file "$libdir/postgis-3": No such file or
                directory<br>
              </div>
              <div dir="auto"><br>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
    </div>
  </body>
</html>

--------------LsaVG01oXxFSByPiCwuy0PTU--