On Tue, Feb 23, 2016 at 11:06 AM, Adrian Klaver <adrian.kla...@aklaver.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.ku...@swfwmd.state.fl.us <mailto:steve.di...@swfwmd.state.fl.us> >> >> > > -- > 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 > 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.
