Обсуждение: [GENERAL] Postgresql - commercial version

Поиск
Список
Период
Сортировка

[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.

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

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" <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

Re: [GENERAL] Postgresql - commercial version

От
"David G. Johnston"
Дата:
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.

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" <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

Re: [GENERAL] Postgresql - commercial version

От
John McKown
Дата:
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

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 <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

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

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