[postgis-tickets] [PostGIS] #5164: "Server closed the connection unexpectedly" when installing PostGis on OS X with M1 chip

[PostGIS]

#5164: "Server closed the connection unexpectedly" when installing PostGis on OS X
with M1 chip
------------------------+---------------------------
  Reporter:  chrisneve  |      Owner:  pramsey
      Type:  defect     |     Status:  new
  Priority:  medium     |  Milestone:  PostGIS 3.2.2
 Component:  postgis    |    Version:  3.2.x
Resolution:             |   Keywords:
------------------------+---------------------------

Old description:

> I am attempting to install Postgis on my newly created Postgresql DB and
> am running into issues doing so.
>
> **Environment**
>
> - OS X (Big Sur, 11.2.3 with a M1 chip)
> - Postgresql version: stable 14.3, installed with homebrew (more
> precisely, with the following syntax: arch -arm64 brew install
> postgresql)
> - Postgis version: stable 3.2.1, installed with homebrew (same)
>
> **What I'm trying to do**
>
> I want to install postgis on my postgresql database as such.
>
> Christophers-MacBook-Air:postgres root# psql -U chrisneve -d mydbname
> psql (14.3)
> Type "help" for help.
>
> mydbname=# create extension postgis;
>
> **The problem**
>
> The above snippet generates this error.
>
> mydbname=# create extension postgis;
> server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !?>
>
> Before trying with psql directly, I executed the same command using
> DataGrip, which generated this error. (I also tried with the "cascade"
> mode: create extension postgis cascade, which generated the same result).
>
> mydbname.public> create extension postgis
> [2022-05-28 10:55:30] An I/O error occurred while sending to the backend.
> [2022-05-28 10:55:30] Unrecoverable error received, the connection is
> spoiled
>
> DataGrip also displayed a popup-style error saying this.
>
> Error [57P03]: FATAL: the database system is in recovery mode
>
> **What I tried**
>
>     I initially didn't know exactly where the error lied, so I started by
> asserting that the problem wasn't with the creation of extensions (for
> whatever reason).
>
> select * from mydbname.pg_catalog.pg_extension
>
> drop extension plpgsql
>
> create extension plpgsql
>
> This worked just fine; other extensions load fine.
>
>     Realising the issue seemed to come from Postgis, I tried removing and
> reinstalling Postgis, and even Postgresql, with homebrew, multiple times.
> It changed nothing.
>
>     I then wanted to install Postgis from a different location of
> https://postgis.net/install/#binary-installers for OS X, but all other
> install mechanisms (other than homebrew) told me not to mix with other
> installations, so I didn't try them.
>
> FWIW, I installed Postgis in the past on an identical DB on a Windows
> machine, so although I'm no Postgis expert I do know the install process.
>
> It would be much appreciated if a Postgis maintainer could help me out
> with this. Is this a new bug with the M1 chips? I can provide logs if it
> helps.
>
> Many thanks, Chris

New description:

 I am attempting to install Postgis on my newly created Postgresql DB and
 am running into issues doing so.

 **Environment**

 - OS X (Big Sur, 11.2.3 with a M1 chip)
 - Postgresql version: stable 14.3, installed with homebrew (more
 precisely, with the following syntax: arch -arm64 brew install postgresql)
 - Postgis version: stable 3.2.1, installed with homebrew (same)

 **What I'm trying to do**

 I want to install postgis on my postgresql database as such.

 Christophers-MacBook-Air:postgres root# psql -U chrisneve -d mydbname
 psql (14.3)
 Type "help" for help.

 mydbname=# create extension postgis;

 **The problem**

 The above snippet generates this error.

 mydbname=# create extension postgis;
 server closed the connection unexpectedly
     This probably means the server terminated abnormally
     before or while processing the request.
 The connection to the server was lost. Attempting reset: Failed.
 !?>

 Before trying with psql directly, I executed the same command using
 DataGrip, which generated this error. (I also tried with the "cascade"
 mode: create extension postgis cascade, which generated the same result).

 mydbname.public> create extension postgis
 [2022-05-28 10:55:30] An I/O error occurred while sending to the backend.
 [2022-05-28 10:55:30] Unrecoverable error received, the connection is
 spoiled

 DataGrip also displayed a popup-style error saying this.

 Error [57P03]: FATAL: the database system is in recovery mode

 **What I tried**

     I initially didn't know exactly where the error lied, so I started by
 asserting that the problem wasn't with the creation of extensions (for
 whatever reason).

 select * from mydbname.pg_catalog.pg_extension

 drop extension plpgsql

 create extension plpgsql

 This worked just fine; other extensions load fine.

     Realising the issue seemed to come from Postgis, I tried removing and
 reinstalling Postgis, and even Postgresql, with homebrew, multiple times.
 It changed nothing.

     I then wanted to install Postgis from a different location of
 https://postgis.net/install/#binary-installers for OS X, but all other
 install mechanisms (other than homebrew) told me not to mix with other
 installations, so I didn't try them.

 FWIW, I installed Postgis in the past on an identical DB on a Windows
 machine, so although I'm no Postgis expert I do know the install process.

 It would be much appreciated if a Postgis maintainer could help me out
 with this. Is this a new bug with the M1 chips? I can provide logs if it
 helps.

 Many thanks, Chris

--
Comment (by pramsey):

 This is almost certainly a packaging problem. You could disambiguate the
 source of the issue by compiling postgis from source and seeing if it
 works in that case (it probably will). Otherwise we lack the tools to
 debug this at the moment (no M1 system in hand).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5164#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.