Postgres Pro
Downloads
Home   >   mailing lists

RE: Installation of PostGIS without internet or with limited internet access - Mailing list pgsql-admin

From Ravindranathan Rinilnath (Ext. - UniCredit)"
Subject RE: Installation of PostGIS without internet or with limited internet access
Date
Msg-id DB9PR09MB5987E1EB7E7E3C041EB8DC56F30D2@DB9PR09MB5987.eurprd09.prod.outlook.com
Whole thread Raw
In response to Re: Installation of PostGIS without internet or with limited internet access  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Installation of PostGIS without internet or with limited internet access
List pgsql-admin
Tree view

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.external@unicredit.eu

Phone: +91 9786285451

OOO Preview: - 29 Apr 2024 – 01 May 2024

 

From: Ron Johnson <ronljohnsonjr@gmail.com>
Sent: Thursday, April 18, 2024 10:43 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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@unitechiberoamericana.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:

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!
Attachment

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: A flaw in treating WITH CHECK OPTION views
Next
From: Rajesh Kumar
Date:
Subject: Bg_writer and checkpointer