Content-Type: multipart/alternative;
 boundary="------------ZqJG0EiHkDx9QiUPVDfnbvNK"
Message-ID: <fc6e84d8-be8e-4cc1-b97c-59e26328effd@mailbox.org>
Date: Tue, 22 Aug 2023 13:37:12 +0200
MIME-Version: 1.0
Subject: Re: Compatibility postgis
Content-Language: en-US
References: <e2e428cd-4c38-4c3f-99c4-df8ac0befe29@mailbox.org>
To: pgsql-admin@lists.postgresql.org
From: Gunnar Wagner <gunnar.wagner@mailbox.org>
Autocrypt: addr=gunnar.wagner@mailbox.org; keydata=
 xsDNBGMCDgYBDADHHV0qxlMGtM0ZrnETPqZQNlP5ztwxS83yg/iTG/EKa74ANhmoX+B4royi
 uJGN84t5jSyenulIGJkBKXoo+E2duQZAWoOmSCXjo8QqAPsYX53KhafQgnRMQqJE2soZnWOg
 M5t4tWLx4hiRisHTpaGU4+8/QfOW9LmCQONbaJVH7pChUV1HwPxohKRQwIf2OXmRVosQNTY/
 GULq4hrzWYeW8qu/pyBDgWfjBjBhJwEosTDv+RObT0ez/+7XQS3+TuNrKVfHY7K6mR33UmXl
 5IYL8Veq1ejO/xuePI865Ww5+oD6GAq2jW4+5qG6Rg/ZDqFy6oZXxZYK2br4XuDnkD5EDpsA
 C6xuwtnZpAdIwHFdYoKcld3b3gGmnYQuZur7FRnvJvduhgVWEwKprvKLCcidQO6F9djcnBQi
 2VbUM/UcOBFEnZybGLJ49X0xdtr2vuwxHJhTkrIlnp2sMgoKgoDTFtSgcH1WvrSTojLVzfQc
 Ys/z2aN5CMaUl8q/y2GvckEAEQEAAc0pR3VubmFyIFdhZ25lciA8Z3VubmFyLndhZ25lckBt
 YWlsYm94Lm9yZz7CwQ0EEwEIADcWIQS2bnJIz9Ob8K9ITlTR6HrFLjqTBwUCYwIOCAUJBaOa
 gAIbAwQLCQgHBRUICQoLBRYCAwEAAAoJENHoesUuOpMH4HEMAKM9u4ymuXxhJfaQ/E9wK5F3
 TPTZSGeyKeXFsvPdLCzc6e4jK5iL5G8HvC0NbMBIxOepsT+p61+0MkLtf4ru0oWPhS9iQaHx
 WmD2ivTti0DhHKS4dR9aMGDIc5OfDZHbY64wB66VqDdetLs25yehVwfaLyILZKhLGw0DI4Cc
 ZI2JMJxUDbId+7cPwCw065l8hKHo5tWPg0QSZW8Qd/zd7iT4ZsxNwLRTML+2Mwc37Zo697e/
 NVJAC8EprBuLD/VoSGo4GDgdZ1+x0VRNAN3m06HVAsyx8zyGXt3h9PBl8PDhX29+xd+RCa1B
 OW1caEOxjAKFYltJ0zccW96j1usClflAhY4zqRstpjBKuUPc2QAW/lrCwUUI+YjhCtNWgymk
 tvoOHkyNTmVDYkFi+cbmt75GnQL7kiX2lDdMVhEzyTM0H9WOj9u8POhvzGfUQZ5c59RLDHyE
 LJIOBI5zs1xK6n9fsA7Vi7T17A/bFAs72uYnbrKU8M9PqfoohtFn7CNhg87AzQRjAg4IAQwA
 wUv8kOL6vvH+dkCSdpB8r73C89jEODN9GCJXTUTgw2JryYsFGu+IHk2h/ixosGG+8EcxfHfK
 4Zbo3F26NwPBdaO7TuXJllRj+/TCVwmETVauzzIlgae34TMjG7l9j5YVWvC/YVyQp3MVScBn
 ZOAupAg30+tUYGAd0CY3wdfxez1kniniT9TN1Zm7C9CJl+fsuEsZeOViYQSM452eDTp1vvxu
 5iy4uaHzNkdkU4xtPNXJ2wuWA3Kz4z/Mhn11xTb02J2YusgY1XIwa0g2SfLIw8mb8st9ZkC2
 h0BJFJPNMd1RJ5kIJX5ZcNZ8YwqilW+jCBxdR4cn61ZQFwKf2GKlV6GEIh2qQeq66e+9uQOw
 YIR2AHkpKG+E/TU9e5ugG9gI8DakXdSvvRAJDrpkNdKWUoMxnA4NowbqWTBpoY9u4ee5fwHu
 2Z2v4pTQNTLgkxYBW1b8IZ7alpDOadXijrwqaOq4jQxKuoY96rf3S2tRaQ8MC4OOXsbO1AD7
 tbbHRBtrABEBAAHCwPwEGAEIACYWIQS2bnJIz9Ob8K9ITlTR6HrFLjqTBwUCYwIOCQUJBaOa
 gAIbDAAKCRDR6HrFLjqTB3ZuDACMeR/BivlnFq+oSM/jR5HBM5Un6+JWUZ7nUzU6eMxqNM6R
 IOhVNBz9gf+Ij5yhaN+1kQenMRf1h7akpWCeZhqVPSnUa4mfYIqE1J2Z7MQPv1EpKDaJILts
 fPAipapca9X3L5SYkQAZDSUk9HgeaNr785DknxBFsOhbkEmD1/faDkPGsH6/gyIWK9pmBsqt
 o05JTQcr5++PqY13QDCqrO+BxxGfClcAGd84bBojMw14xqmvVLtgQyYhk9aD7YK2f74YAhri
 zEOYnnjALfKSbumhowdsUP2IGHJkhGK172+i9aM2E2GX8QCJmJCbW0Oc8SCoRVa51hwbQZV0
 U/B6AfM2yWTFhQfkvKr/QJ1dqEcbpLoAdQqGzRLhyv17nZ5LTmFC61M5tu0ZIgpX6fDKThdr
 +JcacsfAcPpPZMnrr0gP4AYdPsf+GMjCZGMsPL6DYUYJ3Zrubbwg6C081ijvqmIufNRfRgbS
 HV7iRM7+DWg3zo12t44n0PRyyxyYCJcXOjg=
In-Reply-To: <e2e428cd-4c38-4c3f-99c4-df8ac0befe29@mailbox.org>
Archived-At: 
 <https://www.postgresql.org/message-id/fc6e84d8-be8e-4cc1-b97c-59e26328effd%40mailbox.org>
Precedence: bulk

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


compatibility between postgres/GIS 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
>
--------------ZqJG0EiHkDx9QiUPVDfnbvNK
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">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      compatibility between postgres/GIS is a little tricky. <br>
      <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>
  </body>
</html>

--------------ZqJG0EiHkDx9QiUPVDfnbvNK--