Re: postgres oracle emulation question

Thanks to everyone for your comments on postgres oracle emulation. It
was very helpful.

Randy

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Tuesday, March 22, 2005 8:38 PM
To: Lonni J Friedman
Cc: Randy Samberg; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] postgres oracle emulation question

Lonni J Friedman wrote:

>On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
><Randy(dot)Samberg(at)palmsource(dot)com> wrote:
>
>
>>
>>Does anyone know if there is a way in Postgres to emulate Oracle, in
>>other words make Postgres think it is an Oracle database? If so, do
>>you have any idea what percentage of people are doing this, and how
successful they are
>>with this? Also, how is this done? Do you know of any good links
that
>>discuss this. My manager is thinking about replacing a couple of
>>Oracle databases with Postgres, and would like to know the answer to
this question.
>>
>>
>
>You mean make postgres slow, bloated & buggy?
>
>
I am going to assume that was a joke, but it is not helpful.

There is no real way to "emulate" Oracle. The best you could do is to
have some level of software proxy that would understand the Oracle
protocol and then translate that to PostgreSQL but you are looking at a
huge mess.

You would have to consider all the queries and such.

What I can tell you is that it doesn't take much to port Oracle to
PostgreSQL. There are some major differences in feature set but those
can usually be solved programmatically.

Sincerely,

Joshua D. Drake

>
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL