Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8Sr6-009zVZ-Vc for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 29 Nov 2023 22:16:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8Sr5-00DRNJ-BR for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 29 Nov 2023 22:16:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8Sr5-00DRNA-2i for pgsql-pkg-debian@lists.postgresql.org; Wed, 29 Nov 2023 22:16:27 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r8Sr2-0080Ie-HQ for pgsql-pkg-debian@postgresql.org; Wed, 29 Nov 2023 22:16:25 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-40859dee28cso2087645e9.0 for ; Wed, 29 Nov 2023 14:16:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701296182; x=1701900982; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=y/G2WHYo4POYW3tk2pLaZJEAqlJfqv2hgvbqkkcMLa8=; b=QqvBlZbPgMOGgb0dwWO5aIEGrIybqtxtPW4PoUoT4rl5m109415WmNzLS6svjTpvai NdRQNGPTdOil4y+BliQR52bureGMc7Gqx08wc7e4khB/vcVBUv+HFa13q5iEarP6GglP UiZ6yd/Pk1GQnzQZ1erb0xdKMoug/aLAyC05CQkcZGlD+K+XhaSeSygk8gK4hugUZeJ2 KiyMshT72aR2BUjb7NEMGXrlW3sofNLIUXrGeVxC+bMB9nX4iwJVrkvczn48xbkLELLq AD2U1XNTdh1nMR1+PVddSNCsOCIv0gXSFjxr5VmanazGaw6auk/VgkrkFWpeNfnEIx1v thfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701296182; x=1701900982; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=y/G2WHYo4POYW3tk2pLaZJEAqlJfqv2hgvbqkkcMLa8=; b=UURGzKfU+nI4ECd+SyIAGBZ8vqAfJ/5R3dOt6w8suXTQ4kHbr2HcboKfPrmpJ2UwqI rJtxfcGbnrVzLDW02PLqA0G1EWXlSdslB7PlBShVOOhXAEs2PjfwMy7tJ9zn0W+U/wz8 6xgH4KExus1Exc0OMgULx/AKFFO5ECql+GEczKZ/y4k1/6GO2LTCNlprJN4Na56Zcfqr wRIUt50ndXdbxq0ulNiow3bDSRLDcyF8P+NRPMJLN/w1ZBumeHg1UgAH8hNwJrNvNFuB N3SFd8ady/AH3L2MphB3PBE2MAwCp2kjdsVW/0olcZCmVMLw75E5nhvLNsfqLKW3imEf DRfQ== X-Gm-Message-State: AOJu0YwLtXj7kW49qoTqDmhbiaTfJ1U/pJ1H9hzcbiY7lD18l/+HIoGG Ga2xJngTbqOMJ64f9LCt4k9XPEMTK67yBTPwDfo= X-Google-Smtp-Source: AGHT+IEUs4m0WI1869VJ5DtjQC11mNSqBogG2iHB2QhOQS9Y9imIs1nKND2H0yQdRMmO6U0fWrdYErMiKK0pqXz8Jnc= X-Received: by 2002:a05:600c:470f:b0:40b:37ef:3671 with SMTP id v15-20020a05600c470f00b0040b37ef3671mr15673246wmo.38.1701296181875; Wed, 29 Nov 2023 14:16:21 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Imre Samu Date: Wed, 29 Nov 2023 23:16:10 +0100 Message-ID: Subject: Re: "postgis_restore" command in the postgis 3.4 package To: Christoph Berg Cc: pgsql-pkg-debian@postgresql.org Content-Type: multipart/alternative; boundary="0000000000009419ab060b51e2dd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009419ab060b51e2dd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Christoph, Thank you for your help, it really makes sense that "postgis_restore" would be located there. I'm writing to the others to mention that the "--no-install-recommends" parameter is also important. Without it, postgresql-15 would be installed as well. So, the command should be: "apt-get install --no-install-recommends postgis" Here is the complete Dockerfile, which extends the current postgis/postgis images: ''' 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/* ''' Best regards, Imre Christoph Berg ezt =C3=ADrta (id=C5=91pont: 2023. nov. 28= ., K, 23:30): > Re: Imre Samu > > Dear maintainers, > > > > I am seeking assistance regarding an issue brought to attention by a us= er > > [1] of the docker-postgis docker images. > > They noticed that the "postgis_restore" command seems to be missing fro= m > > the new debian postgis 3.4.0 > > "postgresql-15-postgis-3" and "postgresql-15-postgis-3-scripts." > > Neither they nor I have been able to locate it. > > Hi Imre, > > the command is in the "postgis" package: > > postgis: /usr/share/man/man1/postgis_restore.1.gz > postgis: /usr/bin/postgis_restore > > Christoph > --0000000000009419ab060b51e2dd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Christoph,

Thank you for your help, it really ma= kes sense that "postgis_restore" would be located there.

I= 'm writing to the others to mention that the "--no-install-recommends" parameter is also important.
= Without it, postgresql-15 would be installed as well. So, the command shoul= d be:
"apt-get install --no-install-recomm= ends postgis"

Here is the complete Dockerfile, which ext= ends the current postgis/postgis images:
'''
FROM postgis/postgis:16-3.4
RUN set -eux \
=C2=A0 &= ;& apt-get update \
=C2=A0 && apt-get install -y --no-instal= l-recommends \
=C2=A0 =C2=A0 =C2=A0postgis \
=C2=A0 && dpkg -= L postgis \
=C2=A0 && rm -rf /var/lib/apt/lists/*

'= ;''

Best regards,
=C2=A0 Imre

Christoph Berg <myon@debian.org> ezt =C3=ADrta (id=C5= =91pont: 2023. nov. 28., K, 23:30):
Re: Imre Samu
> Dear maintainers,
>
> I am seeking assistance regarding an issue brought to attention by a u= ser
> [1] of the docker-postgis docker images.
> They noticed that the "postgis_restore" command seems to be = missing from
> the new debian postgis 3.4.0
>=C2=A0 "postgresql-15-postgis-3" and "postgresql-15-post= gis-3-scripts."
> Neither they nor I have been able to locate it.

Hi Imre,

the command is in the "postgis" package:

postgis: /usr/share/man/man1/postgis_restore.1.gz
postgis: /usr/bin/postgis_restore

Christoph
--0000000000009419ab060b51e2dd--