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