postgis_restore.pl is missing in postgis/postgis:16-3.4

[OriginalPenguin]

It seems like this should be included in the official docker repository, but it doesn't seem to be anywhere.

Is it omitted on purpose? Why?

What's the easiest way to add it?

If the omission is an error, can you kindly release a new version with it included?

[OriginalPenguin]

I just checked and it is in the alpine verison, and it is only missing in the Debian version.

[ImreSamu]

Thank you for the issue!

It does seem like something is missing.

However, since we also use the Debian PostGIS package, specifically

• postgresql-15-postgis-3 and postgresql-15-postgis-3-scripts,
  • https://github.com/postgis/docker-postgis/blob/master/15-3.4/Dockerfile
• postgresql-16-postgis-3 and postgresql-16-postgis-3-scripts
  • https://github.com/postgis/docker-postgis/blob/master/16-3.4/Dockerfile

I have written to the "pgsql-pkg-debian(at)postgresql(dot)org"
mailing list about this issue.

[ImreSamu]

The postgis_restore command has been moved to the "postgis" Debian package.
If you need it urgently, you should also install this package.

I have created a Dockerfile for reference:

FROM postgis/postgis:16-3.4
RUN set -eux \
      && apt-get update \
      && apt-get install -y --no-install-recommends \
           postgis \
      && dpkg -L postgis \     
      && rm -rf /var/lib/apt/lists/*

and in the log: /usr/bin/postgis_restore

#5 5.691 + dpkg -L postgis
#5 5.698 /.
#5 5.698 /usr
#5 5.698 /usr/bin
#5 5.698 /usr/bin/pgsql2shp
#5 5.698 /usr/bin/pgtopo_export
#5 5.698 /usr/bin/pgtopo_import
#5 5.698 /usr/bin/postgis
#5 5.698 /usr/bin/postgis_restore          <------ now here 
#5 5.698 /usr/bin/raster2pgsql
#5 5.698 /usr/bin/shp2pgsql

I am strongly considering including this package in the basic postgis/postgis Debian images, but that will take a bit more time. Therefore, the quickest workaround for now is to extend the current postgis images.

EDIT:

• Development images (arm64+amd64) available https://github.com/ImreSamu/docker-postgis/blob/master/README.md
  • imresamu/postgis:16-3.4-bullseye
  • imresamu/postgis:16-3.4-bookworm
• see: https://github.com/imresamu/docker-postgis/blob/master/16-3.4/bullseye/Dockerfile