Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 11 with SSL on Linux - Mailing list pgsql-general

From Susan Joseph
Subject Re: PostgreSQL 11 with SSL on Linux
Date
Msg-id 2130258060.1161730.1591294985701@mail.yahoo.com
Whole thread Raw
In response to Re: PostgreSQL 11 with SSL on Linux  (Mohammed Bhatti <mohammed.bhatti1@gmail.com>)
List pgsql-general
Tree view
OK thanks, I figured I had something messed up in my thought process.  I will work through these steps and let you know how it goes.

Susan


-----Original Message-----
From: Mohammed Bhatti <mohammed.bhatti1@gmail.com>
To: Susan Joseph <sandajoseph@verizon.net>
Cc: ahodgson@lists.simkin.ca <ahodgson@lists.simkin.ca>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Sent: Thu, Jun 4, 2020 2:14 pm
Subject: Re: PostgreSQL 11 with SSL on Linux



On Thu, Jun 4, 2020 at 1:50 PM Susan Joseph <sandajoseph@verizon.net> wrote:
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.

If I run rpm -qa | grep postgres

I get postgresql-libs-9.2.24-4.el7_8.x86_64


When I run:       rpm -ql postgresql-libs-9.2.24-4.el7_8.x86_64  I just get a list of libraries. 



I am not an SA, I am more of an engineer and have been working with the PostgreSQL I installed by building it so not really used to RPM.   I have used YUM but that was with a connected server.

How do I find all the packages that I need to have to do an install locally?

-----Original Message-----
From: Alan Hodgson <ahodgson@lists.simkin.ca>
To: pgsql-general@lists.postgresql.org
Sent: Thu, Jun 4, 2020 1:36 pm
Subject: Re: PostgreSQL 11 with SSL on Linux

On Thu, 2020-06-04 at 17:32 +0000, Susan Joseph wrote:
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?


The server stuff is in postgresql11-serverif you're using the community rpms.

Hi,

I've had to do this in the past and I think you probably want to do this:
1. connect to a machine that has access to repos
3. where it says "Direct RPM Download", click on the "direct download" link
5. click on "11  RHEL/CentOS/Oracle Linux 7 - x86_64" or whatever is the appropriate version you are looking for
7. under "Available Groups", click on the " PostgreSQL Database Server 11 PGDG" link
9. here, you'll see four packages listed
10. click on each, which takes you to a page where the latest package is available
11. repeat for all four and download all of the four and copy then to your offline server, so for example, /tmp
12. then try and do an rpm -ivh /tmp/<name_of_pkg>, so for example rpm -ivh postgresql11-server-11.8-1PGDG.rhel7.x86_64 
13. I believe this should place the postgres stuff in /var/lib/pgsql
14. additional packages can be downloaded as needed

--
mohammed

pgsql-general by date:

Previous
From: Mohammed Bhatti
Date:
Subject: Re: PostgreSQL 11 with SSL on Linux
Next
From: Adrian Klaver
Date:
Subject: Re: Monitoring for long running transactions