Re: Installation of PostGIS without internet or with limited internet access

Hello, we are deploying an application that uses maps and represents
geographical data, so the deployment requires the installation of PostGIS
as a necessary condition on PostgreSQL.

Ramiro Sanchez

Project Leader

ramiros(at)unitechiberoamericana(dot)com

www.unitechiberoamericana.com <https://unitechiberoamericana.com/>

<https://www.linkedin.com/company/84574311/>
<https://www.facebook.com/Unitech-Iberoamericana-106921288830479>
<https://www.instagram.com/unitechiberoamericana/>
<https://twitter.com/UnitechIbero>

El jue, 18 abr 2024 a las 21:58, Ravindranathan Rinilnath (Ext. -
UniCredit) (<RRAVINDRANATHAN(dot)external(at)unicredit(dot)eu>) escribió:

> what is the use of this postgis, can you please give the sample use case
> of it?
>
>
>
> Warm regards,
>
>
>
> *Rinilnath R*
>
> Technical Lead, BFSI
>
> Tata Consultancy Services
>
> Email: rravindranathan(dot)external(at)unicredit(dot)eu
>
> Phone: +91 9786285451
>
> OOO Preview: - 29 Apr 2024 – 01 May 2024
>
> <http://www.tcs.com/>
>
>
>
> *From:* Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> *Sent:* Thursday, April 18, 2024 10:43 PM
> *To:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: Installation of PostGIS without internet or with limited
> internet access
>
>
>
> On Thu, Apr 18, 2024 at 10:20 AM Ramiro Sanchez <
> ramiros(at)unitechiberoamericana(dot)com> wrote:
>
> Hi, we need to install PostGIS on a RHEL 8 server, which contains highly
> sensitive information and therefore does not have internet access.
>
> So, we attempted an offline installation but were unsuccessful.
>
> As an alternative, we enabled internet access to specific required sites
> for the installation, for example:
>
> -
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> -
> https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
> -
> https://cdn.redhat.com/content/dist/rhel8/8/x86_64/appstream/os/repodata/repomd.xml
> -
> https://mirrors.fedoraproject.org/metalink?repo=epel-8&arch=x86_64&infra=$infra&content=$contentdir
>
> It's worth noting that this alternative also didn't work, as several
> errors occurred.
>
> So, we have the following questions:
>
> 1. Is it possible to perform an offline installation of PostGIS? If
> so, how?
> 2. Is it possible to obtain a list of all the required sites during
> the installation of PostGIS? This way, it would be possible to enable
> internet access only for these sites.
>
>
>
> I manually* download the relevant files from
> https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-8-x86_64
> and https://download.postgresql.org/pub/repos/yum/15/redhatrhel-8-x86_64
> to my laptop, then use WinSCP to copy them to my firewall-restricted Linux
> servers. Then "yum install". Works like a charm.
>
>
>
> Yes, I had to manually determine the package names, but that was a
> one-time process. Now, I just update the version numbers in my Windows
> shell script.
>
>
>
> *technically, with a PowerShell script.
>
> This e-mail is confidential and may also contain privileged information.
> If you are not the intended recipient you are not authorised to read,
> print, save, process or disclose this message. If you have received this
> message by mistake, please inform the sender immediately and delete this
> e-mail, its attachments and any copies.
> Any use, distribution, reproduction or disclosure by any person other than
> the intended recipient is strictly prohibited and the person responsible
> may incur penalties.
> Thank you!
>

--

Este correo electrónico y, en su caso, cualquier fichero anexo al mismo,
contiene información de carácter confidencial exclusivamente dirigida a su
destinatario o destinatarios. Queda prohibida su divulgación, copia o
distribución a terceros sin la previa autorización escrita de Unitech. En
el caso de haber recibido este correo electrónico por error, se ruega
notificar inmediatamente esta circunstancia mediante reenvío a la dirección
electrónica del remitente.

The information in this e-mail and in any
attachments is confidential and solely for the attention and use of the
named addressee(s). You are hereby notified that any dissemination,
distribution or copy of this communication is prohibited without the prior
written consent of Unitech. If you have received this communication in
error, please, notify the sender by reply e-mail.