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