Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL Packages

PostgreSQL Packages

From
rajdeep limbu
Date:
Hello Team,

I have some query regarding the PostgreSQL installation and its packages. I have installed PostgreSQL 9.5 version for CentOS 7 from this link https://www.postgresql.org/download/linux/redhat/ 

These are the packages which I found post installation ;

image.png

I wanted to see the generated files or contents which are associated with these packages. Where can I see the postgresql-runtime packages?? are they separately installed? Can somebody from the support team help me out with this?

Apart from this, I had a query regarding the naming convention followed by PostgreSQL for their client and server packages. For all the server installations, they call it PostgreSQL Server. However, for the client related installations,
they nowhere mention that it is a PostgreSQL client rather they say it as PostgreSQL ( at least for CentOS). what about Ubuntu, Debian, and other installations? Can you throw some light on this ??

Your help is much appreciated.

Thanks,
Rajdeep



Attachment

Re: PostgreSQL Packages

From
Christoph Berg
Date:
Re: rajdeep limbu 2019-03-29 <CAG5O28cyU64zRhooQLovVzci0QNnsZfjQh=z_LV1eKFOkRsVPQ@mail.gmail.com>
> Apart from this, I had a query regarding the naming convention followed by
> PostgreSQL for their *client* and *server *packages. For all the server
> installations, they call it PostgreSQL Server. However, for the client
> related installations,

"client" is the "psql" command line client, and other binaries like
pg_dump.

> they nowhere mention that it is a PostgreSQL client rather they say it as
> PostgreSQL ( at least for CentOS). what about Ubuntu, Debian, and other
> installations? Can you throw some light on this ??

On CentOS, the postgresql package has the clients, and the server is
in the postgresql-server package.

On Debian, the postgresql package has the server, and the clients are
in the postgresql-client package.

I'm not sure I got your questions correctly. What's the reason you are
asking?

Christoph

Re: PostgreSQL Packages

From
rajdeep limbu
Date:
Hi Christoph,

Thank you for your prompt reply.

We are building an in-house catalog for different software applications. So, we had few confusions regarding these PostgreSQL packages and thus wrote an email to you. 

It would be very kind if you can help me clear a few more doubts I have :

1)  Are postgresql-runtime packages separately installable ?? what are these packages? I could not find these packages after I am done with the PostgreSQL installation.

2) There are several other PostgreSQL packages we have discovered such as PostgreSQL-contrib, PostgreSQL-plpython, postgresql-runtime ( to name a few).  Can you provide me a list of packages which are not possible to installed separately and gets installed along with the PostgreSQL server?

3) On CentOS, the postgresql package has the clients, and the server is
in the postgresql-server package. (Is this applicable to the entire Red Hat family?)

On Debian, the postgresql package has the server, and the clients are
in the postgresql-client package. ( (Is this applicable to Ubuntu also?)

Thanks & Regards,
Rajdeep


On Fri, Mar 29, 2019 at 5:39 PM Christoph Berg <myon@debian.org> wrote:
Re: rajdeep limbu 2019-03-29 <CAG5O28cyU64zRhooQLovVzci0QNnsZfjQh=z_LV1eKFOkRsVPQ@mail.gmail.com>
> Apart from this, I had a query regarding the naming convention followed by
> PostgreSQL for their *client* and *server *packages. For all the server
> installations, they call it PostgreSQL Server. However, for the client
> related installations,

"client" is the "psql" command line client, and other binaries like
pg_dump.

> they nowhere mention that it is a PostgreSQL client rather they say it as
> PostgreSQL ( at least for CentOS). what about Ubuntu, Debian, and other
> installations? Can you throw some light on this ??

On CentOS, the postgresql package has the clients, and the server is
in the postgresql-server package.

On Debian, the postgresql package has the server, and the clients are
in the postgresql-client package.

I'm not sure I got your questions correctly. What's the reason you are
asking?

Christoph

Re: PostgreSQL Packages

From
Christoph Berg
Date:
Re: rajdeep limbu 2019-03-29 <CAG5O28c+kjZkjue9qGVYgr1OvE=OzUTBAiE+xhSKD_s+tzfLcA@mail.gmail.com>
> 1)  Are *postgresql-runtime* packages separately installable ?? what are
> these packages? I could not find these packages after I am done with the
> PostgreSQL installation.

I have never heard about "runtime" packages.

> 3) On CentOS, the postgresql package has the clients, and the server is
> in the postgresql-server package. (*Is this applicable to the entire Red
> Hat family?*)

Yes.

> On Debian, the postgresql package has the server, and the clients are
> in the postgresql-client package. ( (*Is this applicable to Ubuntu also?*)

Yes.

Christoph

Re: PostgreSQL Packages

From
rajdeep limbu
Date:
Hi  Christoph,

This is regarding the runtime packages, I am talking about this 

Do you have any idea about these packages? Can they be separately installed ? Or they always have some dependency on some other program or package? 

Thanks,
Rajdeep

On Fri, 29 Mar 2019 at 6:56 PM, Christoph Berg <myon@debian.org> wrote:
Re: rajdeep limbu 2019-03-29 <CAG5O28c+kjZkjue9qGVYgr1OvE=OzUTBAiE+xhSKD_s+tzfLcA@mail.gmail.com>
> 1)  Are *postgresql-runtime* packages separately installable ?? what are
> these packages? I could not find these packages after I am done with the
> PostgreSQL installation.

I have never heard about "runtime" packages.

> 3) On CentOS, the postgresql package has the clients, and the server is
> in the postgresql-server package. (*Is this applicable to the entire Red
> Hat family?*)

Yes.

> On Debian, the postgresql package has the server, and the clients are
> in the postgresql-client package. ( (*Is this applicable to Ubuntu also?*)

Yes.

Christoph

Re: PostgreSQL Packages

From
Christoph Berg
Date:
Re: rajdeep limbu 2019-03-29 <CAG5O28fTigNt22Pm-A+APnitX1FmUEW2uo=g3j2hRdap+4zqhA@mail.gmail.com>
> This is regarding the runtime packages, I am talking about this
> https://centos.pkgs.org/7/centos-sclo-rh-testing-x86_64/postgresql92-runtime-1.1-20.el7.x86_64.rpm.html
> 
> Do you have any idea about these packages? Can they be separately installed
> ? Or they always have some dependency on some other program or package?

What happened when you tried installing that?

Christoph

Re: PostgreSQL Packages

From
rajdeep limbu
Date:
I am not able to do that .

On Fri, 29 Mar 2019 at 8:57 PM, Christoph Berg <myon@debian.org> wrote:
Re: rajdeep limbu 2019-03-29 <CAG5O28fTigNt22Pm-A+APnitX1FmUEW2uo=g3j2hRdap+4zqhA@mail.gmail.com>
> This is regarding the runtime packages, I am talking about this
> https://centos.pkgs.org/7/centos-sclo-rh-testing-x86_64/postgresql92-runtime-1.1-20.el7.x86_64.rpm.html
>
> Do you have any idea about these packages? Can they be separately installed
> ? Or they always have some dependency on some other program or package?

What happened when you tried installing that?

Christoph

Re: PostgreSQL Packages

From
Christoph Berg
Date:
Re: rajdeep limbu 2019-03-29 <CAG5O28cVwOE8RkVSCOfZO+6_XgsK7CBZut-zM7+83RK6JjJrmw@mail.gmail.com>
> I am not able to do that .

Grab VirtualBox and a CentOS 7 VM and just do it?

Christoph

Re: PostgreSQL Packages

From
rajdeep limbu
Date:
Okk will try.. Thanks!

On Fri, 29 Mar 2019 at 9:00 PM, Christoph Berg <myon@debian.org> wrote:
Re: rajdeep limbu 2019-03-29 <CAG5O28cVwOE8RkVSCOfZO+6_XgsK7CBZut-zM7+83RK6JjJrmw@mail.gmail.com>
> I am not able to do that .

Grab VirtualBox and a CentOS 7 VM and just do it?

Christoph

Re: PostgreSQL Packages

From
Devrim Gündüz
Date:
Hi,

On Fri, 2019-03-29 at 20:53 +0530, rajdeep limbu wrote:
> This is regarding the runtime packages, I am talking about this
> https://centos.pkgs.org/7/centos-sclo-rh-testing-x86_64/postgresql92-runtime-1.1-20.el7.x86_64.rpm.html

That is an SCL package, and we (community) don't support/have it.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment