Thanks to everyone for your comments on postgres oracle emulation. It was very helpful.
Randy -----Original Message----- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 8:38 PM To: Lonni J Friedman Cc: Randy Samberg; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres oracle emulation question Lonni J Friedman wrote: >On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg ><[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
