Thread: PostgreSQL 11 with SSL on Linux

Susan Joseph <sandajoseph@verizon.net> writes:
> So the other issue I have is that I am running this on a server that is not connected to the Internet.  So I have
downloadedthe RPM file but I can't figure out how to install it without it trying to access files on the Internet.  Are
thereother libraries I need to include in my download for this to work on a non-networked server? 

Are you using the right install tool?  "rpm -i" shouldn't result in any
nonlocal accesses.  Tools like yum or dnf will, because they're meant to
fetch from nonlocal repositories.

            regards, tom lane

So when I run rpm -i it says that the package is installed, but I can't find a postgresql directory with all the files and executables.  So what am I missing?

Susan Joseph <sandajoseph@verizon.net> writes:
> So when I run rpm -i it says that the package is installed, but I can't find a postgresql directory with all the
filesand executables.  So what am I missing? 

Looking in the right place, perhaps ;-).  If the package is installed
then "rpm -ql" will list all the files it installed.

There are a couple of different layouts that different packagers like to
use, so you might be accustomed to something different than what this
particular package used.

Related to that is that there are almost always sub-packages; it's
likely that in addition to an rpm named just postgresql-NNN you need
postgresql-server-NNN, and maybe some other bits.

            regards, tom lane

Susan Joseph <sandajoseph@verizon.net> writes:
>  OK, when I went to PostgreSQL to get the rpm file to install I was given:
> yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> I put the file  pgdg-redhat-repo-latest.noarch.rpm in my /tmp directory and ran rpm -i on the file.

I think you've got a fundamental misunderstanding here.  That package is
not Postgres; it's just a config file that tells your dnf/yum installation
where it can download community Postgres RPMs from.

If you want to do this on a machine without an internet connection,
you need to get the actual Postgres RPMs from that repo and install
them manually with "rpm -i".  I don't recall which subdirectory on
download.postgresql.org has what you want, but if you can't find it
by browsing, a look into the installed yum config file should help.

> If I run rpm -qa | grep postgres
> I get postgresql-libs-9.2.24-4.el7_8.x86_64

This is a postgresql-libs package from Red Hat, not from the community.
There's nothing particularly wrong with Red Hat's packaging, except
that it tends to be well behind community releases because that's
what they think the RHEL distribution ought to be.  The main problem
from your perspective is the risk of confusion with the libraries that
community PG11 RPMs will bring in.  You might try a test deinstallation
of that RPM first, and see if it cascades to removing anything you can't
live without.

            regards, tom lane

Hi Susan,

you need to install the openssl rpm if you don't have that already. But it should be a standard package in all Linux
distributions,so it should be in your repository. 

Exmaple from my host:
$ rpm -qa openssl
openssl-1.1.0i-lp151.1.1.noarch

Cheers,
Paul

> On 04. Jun, 2020, at 18:50, Susan Joseph <sandajoseph@verizon.net> wrote:
>
> So the other issue I have is that I am running this on a server that is not connected to the Internet.  So I have
downloadedthe RPM file but I can't figure out how to install it without it trying to access files on the Internet.  Are
thereother libraries I need to include in my download for this to work on a non-networked server? 
>
>
>
> -----Original Message-----
> From: Magnus Hagander <magnus@hagander.net>
> To: Susan Joseph <sandajoseph@verizon.net>
> Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
> Sent: Thu, Jun 4, 2020 11:14 am
> Subject: Re: PostgreSQL 11 with SSL on Linux
>
>
>
> On Thu, Jun 4, 2020 at 5:01 PM Susan Joseph <sandajoseph@verizon.net> wrote:
> Can someone tell me if there is a yum version of PostgreSQL 11 that can be installed on Linux that has SSL enabled?
Currentlythe only way I have gotten SSL turned on in PostgreSQL is by doing the following commands: 
>
>     • tar xzvf /tmp/postgresql-11.2.tar.gz -C /data
>     • mv /data/postgresql-11.2 /data/pgsql
>     • cd /data/pgsql
>     • ./configure --prefix=/data/pgsql --without-readline --without-zlib --with-openssl >> conf.log
>     • make
>     • make install
>
> All the PostgreSQL versions available om yum from the postgresql.org site have SSL enabled. Just install using the
instructionsfrom https://www.postgresql.org/download/. 
>
> --
>  Magnus Hagander
>  Me: https://www.hagander.net/
>  Work: https://www.redpill-linpro.com/