Re: Oracle to PostgreSQL transition?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Robert Treat <rob(at)xzilla(dot)net>
Cc: Szymon Guz <mabewlun(at)gmail(dot)com>, Roy Anderson <roy(dot)anderson(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to PostgreSQL transition?
Date: 2013-04-05 16:28:18
Message-ID: 515EFBA2.3030506@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 04/05/2013 08:03 AM, Robert Treat wrote:
>
> On Fri, Apr 5, 2013 at 2:12 AM, Szymon Guz <mabewlun(at)gmail(dot)com> wrote:
>> On 4 April 2013 16:16, Roy Anderson <roy(dot)anderson(at)gmail(dot)com> wrote:
>>>
>>> Hey all,
>>>
>>> We have a very robust Oracle and SQL Server presence at work but we're
>>> looking to farm out some of the load to PostgreSQL to limit costs. I'm
>>> curious if there are any DBAs out there who have gone down this route
>>> before. Any tips, tricks, failures, successes, etc.? I would just like to
>>> hear some first-hand commentary on this topic.
>>>
>>> Thank you so much!

Yes, we have done this for customers on more than one occasion. The
single biggest tip I can give you is to remember that PostgreSQL is not
Oracle. You are porting to PostgreSQL, don't expect it to act like
Oracle. As long as you keep that in mind, and you aren't running RAC
things are pretty straightforward. They can also be quite a bit easier
(and cheaper) to get a lot of external functionality such as replication.

Sincerely,

Joshua D. Drake

--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-04-05 16:30:06 Re: upgrading from V8.3.4 to V9.2.4
Previous Message Shaun Thomas 2013-04-05 16:12:06 Re: Oracle to PostgreSQL transition?