Postgresql - commercial version

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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 Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh <
krithikavenkatesh31@gmail.com> 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

​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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Fri, Jul 7, 2017 at 9:04 AM, Krithika Venkatesh <
krithikavenkatesh31@gmail.com> 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

​I don't have access to EDB, just the community version (from the Fedora
RPM). But from looking at the manual:
https://www.enterprisedb.com/docs/en/9.6/DB_Compat_Oracle_Reference/Database_Compatibility_for_Oracle_Developers_Reference_Guide.1.203.html

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

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:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general