Thread: [GENERAL] Postgresql - commercial version
Hi,
I have postgreSQL 9.5 installed in the server. Is it possible to find whether the installed postgresql is enterprise db or an open source version through a query.
Thanks in Advance.
On 07/07/2017 06:52 AM, Krithika Venkatesh wrote: > Hi, > > I have postgreSQL 9.5 installed in the server. Is it possible to find > whether the installed postgresql is enterprise db or an open source > version through a query. Not sure, but I would try: select version(); > > Thanks in Advance. -- Adrian Klaver adrian.klaver@aklaver.com
select version () gives me output something like this
PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit.
Is there any other way to find
On 07-Jul-2017 7:28 PM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:
On 07/07/2017 06:52 AM, Krithika Venkatesh wrote:Hi,
I have postgreSQL 9.5 installed in the server. Is it possible to find whether the installed postgresql is enterprise db or an open source version through a query.
Not sure, but I would try:
select version();
Thanks in Advance.
--
Adrian Klaver
adrian.klaver@aklaver.com
select version () gives me output something like thisPostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit.Is there any other way to find
If memory serves the commercial version put out by EnterpriseDB uses a 4-part versioning scheme so the above would seem to be the community version you are looking at.
Otherwise maybe someone with access will be kind enough to provide the version their 9.5 version of the EnterpriseDB install outputs for comparison.
You can always check the O/S package manager and try and figure out how it was installed.
David J.
On 07/07/2017 07:04 AM, Krithika Venkatesh wrote: > select version () gives me output something like this > > PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 > 20080704 (Red hat 4.1.2-55), 64 bit. > > Is there any other way to find It depends on what you are trying to determine: 1) If you are looking at a database installed from here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads#linux Then it will the same as the community database, it was just installed differently. 2) If you are looking at one of EDB's value added products you have to pay for, then I would suspect there will tables/functions/etc that do not exist in the community version you could query for. > > On 07-Jul-2017 7:28 PM, "Adrian Klaver" <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 07/07/2017 06:52 AM, Krithika Venkatesh wrote: > > Hi, > > I have postgreSQL 9.5 installed in the server. Is it possible to > find whether the installed postgresql is enterprise db or an > open source version through a query. > > > Not sure, but I would try: > > select version(); > > > Thanks in Advance. > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
select version () gives me output something like thisPostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit.Is there any other way to find
I don't have access to EDB, just the community version (from the Fedora RPM). But from looking at the manual:
you might try:
SELECT * FROM PRODUCT_COMPONENT_VERSION;
This table does not exist in the version which I have, and so I am guessing that it would be a decent test.
Veni, Vidi, VISA: I came, I saw, I did a little shopping.
Maranatha! <><
John McKown
John McKown
You have the open source version installed. Now where it was installed from is a different story.
EnterpriseDB Advanced Server will look like:
EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit
T
On Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh <krithikavenkatesh31@gmail.com> wrote:
select version () gives me output something like thisPostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit.Is there any other way to findOn 07-Jul-2017 7:28 PM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:On 07/07/2017 06:52 AM, Krithika Venkatesh wrote:Hi,
I have postgreSQL 9.5 installed in the server. Is it possible to find whether the installed postgresql is enterprise db or an open source version through a query.
Not sure, but I would try:
select version();
Thanks in Advance.
--
Adrian Klaver
adrian.klaver@aklaver.com
On 7/7/2017 8:22 AM, Terry Schmitt wrote: > You have the open source version installed. Now where it was installed > from is a different story. > if its a redhat/centos/fedora type system, try... rpm -qa |grep ^postgres if it was installed from rpm's, the full names of the rpms will clue you in. also, see what path postgres's tools are installed in, the RPM versions install everything in /usr/pgsql-9.x/bin while EDB typically installs to /opt or something. -- john r pierce, recycling bits in santa cruz