-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Lonni J
Friedman
Sent: Wednesday, March 23, 2005 6:06 AM
To: Joshua D. Drake
Cc: Randy Samberg; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres oracle emulation question
On Tue, 22 Mar 2005 20:38:13 -0800, Joshua D. Drake
<jd@commandprompt.com> wrote:
> Lonni J Friedman wrote:
>
> >On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
> ><Randy.Samberg@palmsource.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.
No, it wasn't a joke. I'm forced to maintain Oracle databases every
day, and I've yet to find any redeeming qualities, so it baffles me
why anyone would want to emulate them.
>>
1. Excellent stability
2. Excellent scalability
3. Superb toolset
4. After-market support products abound
5. Stable, debugged access tools like the ODBC/OLEDB/.NET drivers
On the downside:
1. $$$!!!
2. Installation is bad, even for a simple client.
3. Reinstallation/upgrade is always a nightmare.
4. God help you if your Oracle home should ever get moved or you move
to a different disk drive.
5. Multiple OCI DLLs are sure to bring lots of intriguing surprises.
<<
On the whole, it's not terrible if you can afford it.