Re: [GENERAL] Postgresql - commercial version

[John R Pierce]

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

Re: [GENERAL] Postgresql - commercial version

[Terry Schmitt]

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 <
krithikavenkates...@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
>
> On 07-Jul-2017 7:28 PM, "Adrian Klaver"  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.kla...@aklaver.com
>>
>

Re: [GENERAL] Postgresql - commercial version

[John McKown]

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

Re: [GENERAL] Postgresql - commercial version

[Adrian Klaver]

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" > 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.kla...@aklaver.com 




--
Adrian Klaver
adrian.kla...@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

Re: [GENERAL] Postgresql - commercial version

[David G. Johnston]

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

Re: [GENERAL] Postgresql - commercial version

[Krithika Venkatesh]

 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"  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.kla...@aklaver.com
>

Re: [GENERAL] Postgresql - commercial version

[Adrian Klaver]

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.kla...@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

[GENERAL] Postgresql - commercial version

[Krithika Venkatesh]

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.