Re: PostgreSQL flavors

On Tue, Feb 23, 2016 at 11:06 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
>
>> Hello, my first post to the list, thank you for this place to ask
>> questions and get help.
>>
>
> Welcome.
>
>
>> Our management has tasked me with devising a plan to migrate our
>> existing databases from Oracle to PostgreSQL. I’m researching and
>> getting familiar with PostgreSQL before getting a Linux box to start
>> learning and staging. I have a long way to go, but it will be fun.
>>
>> Out of the gate, I can see different PostgreSQL products – PostgreSQL,
>> PostgreSQLPlus, EnterpriseDB Advanced Server.
>>
>
> Well you are looking at the community version PostgreSQL(
> http://www.postgresql.org/) versus versions created by EnterpriseDB(
> http://www.enterprisedb.com) EDB has the community version wrapped in an
> installer which is free. Its other versions have addons and are fee based.
> There are also quite a few other companies that support Postgres:
>
> http://www.postgresql.org/support/professional_support/northamerica/
>
>
>> For staging I’ll likely start with the vanilla version. I’ve been
>> searching for a comparison of different product sets; I’ve found some
>> things, but in other places different information. There is a lot to
>> sift through. For example, we are now using non-active Data Guard to a
>> standby for disaster recovery. What is the different on this
>>
>
> I would take a look here:
>
> http://www.postgresql.org/docs/9.5/interactive/backup.html
>
> and here:
>
> http://www.postgresql.org/docs/9.5/interactive/high-availability.html
>
> in particular:
>
>
> http://www.postgresql.org/docs/9.5/interactive/different-replication-solutions.html
>
> Table 25-1
>
> functionality in the 3 products? Or perhaps there are more products than
>> I’ve found. Cost will be a factor for us, but I also consider that
>> costs are not only product and maintenance costs, there are DBA and
>> developer migration costs as well.
>>
>
> I would suggest starting with the community version:
>
> http://www.postgresql.org/download/
>
> If you do not want to set up an entire machine, set up a Linux VM and
> install Postgres. It will not be the best indication of performance, but it
> will allow you to explore the feature set.
>
>
>> Any insights or information is appreciated.
>>
>
> Since you are looking at migrating from Oracle, see here:
>
> http://ora2pg.darold.net/
>
>
>> *********************************************************
>>
>> Sherrie Kubis
>>
>> Sr. Oracle DBA
>>
>> Information Technology Bureau
>>
>> Southwest Florida Water Management District
>>
>> 2379 Broad Street
>>
>> Brooksville, FL 34604-6899
>>
>> 352.796.7211 x4033
>>
>> sherrie(dot)kubis(at)swfwmd(dot)state(dot)fl(dot)us <mailto:steve(dot)dicks(at)swfwmd(dot)state(dot)fl(dot)us>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Basically, PostgreSQL is the free, public domain version. PostgreSQLPlus
and EDB Advanced Server are enhanced versions of PostgreSQL by
EnterpriseDB.com, However, there is a maintenance fee for the EDB Advanced
Server.
PostgreSQL Plus is a Cloud based version of PostgreSQL, and I believe there
is also a fee involved for that too. Your best path is to evaluate how much
memory and storage is currently used for the Oracle DB, then obtain a Linux
box based on that. You should then install the latest free version of
PostgreSQL from one of the urls at http://www.postgresql.org/download/
based on which O/S you will be using.
Note that the latest GA version of PostgreSQL is 9.5.1
FYI, EnterpriseDB.com does have a Oracle to PostgreSQL migration tool (and
service) but there is also a fee involved for both.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.