Search Postgresql Archives

Re: PostgreSQL flavors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Congratulations on the decision and welcome.

As an overview, there is the PostgreSQL *project* which is run by the PostgreSQL Global Development Group (PgDG) with contributors around the world most of whom work for a variety of companies that either use or support PostgreSQL. PostgreSQL is BSD-licensed open-source software. PgDG operates these mailing lists.

Within the PostgreSQL ecosystem you will find numerous commercial and non-commercial entities that provide:

-Custom/commercial/extended products based on PostgreSQL (i.e. EnterpriseDB and others) - some of which are designed to provide a level of Oracle compatibility

-Commercial and open-source tools that extend, support or work with PostgreSQL (you may want to look at Ora2Pg - a tool to migrate Oracle to PostgreSQL)

-Development services

-Training

-DBA and support services (i.e. PGExperts)

-User-groups (very helpful but I don't see one in Florida: http://www.postgresql.org/community/user-groups/)

-Conferences (http://www.postgresql.org/about/events/)

-Books and magazines

I'd agree with your plan to start with the core open-source PostgreSQL software to learn then progress to other products/projects as needs dictate.

Cheers,
Steve


On Tue, Feb 23, 2016 at 7:51 AM, Sherrie Kubis <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx> wrote:

Hello, my first post to the list, thank you for this place to ask questions and get help.

 

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. 

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

 

Any insights or information is appreciated.

 

 

*********************************************************

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.kubis@xxxxxxxxxxxxxxxxxx

 

Please take a moment to answer a few questions and let us how we’re doing.

 

IMPORTANT NOTICE

E-mails made or received in conjunction with the official business of the District are public records.  All e-mails sent to and from this address are automatically archived.  For more information regarding the State of Florida public records laws, please visit www.myflorida.com.

 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux