Re: PostgreSQL 11 with SSL on Linux

On Thu, Jun 4, 2020 at 1:50 PM Susan Joseph <sandajoseph(at)verizon(dot)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(at)lists(dot)simkin(dot)ca>
> To: pgsql-general(at)lists(dot)postgresql(dot)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
2. go here: https://www.postgresql.org/download/linux/redhat/
3. where it says "Direct RPM Download", click on the "direct download" link
4. this takes you here: https://yum.postgresql.org/rpmchart.php
5. click on "11 RHEL/CentOS/Oracle Linux 7 - x86_64" or whatever is the
appropriate version you are looking for
6. this takes you here:
https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/
7. under "Available Groups", click on the " PostgreSQL Database Server 11
PGDG" link
8. which takes you here:
https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/postgresqldbserver11.group.html
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