Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?

From: Ian Barwick <barwick(at)gmail(dot)com>
To: Troyston Campano <troygeekdatabase(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?
Date: 2005-01-20 08:06:44
Message-ID: 1d581afe05012000067864ca78@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano
<troygeekdatabase(at)gmail(dot)com> wrote:
>
> Hello,
>
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto a "production" server
> that currently runs Oracle. Are there any problems with running Postgresql
> and Oracle on the same machine? I mean, I've heard that the way Sybase and
> DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is
> installed on the same machine as the Sybase Server (something about UDB
> eating up all the memory and not giving it back to Sybase).
>
> Are there any issues running Postgresql and Oracle on the same
> machine…anything special to know about memory, disk layout, and things like
> that? I just want to make sure the two engines play together on this same
> server. I had a hard time finding information about this via google.

For testing purposes there shouldn't be any problems, at least in a
*NIX environment. PostgreSQL is very undemanding and compared to
Oracle is positively minuscule (at least as far as its "installation
footprint" goes). I've run PostgreSQL, MySQL, DB2 and Oracle on the
same development machine without any issues. Of course if another
application is in constant use on a production server PostgreSQL won't
perform as well as it could.

Ian Barwick

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lakshmi Narayanan 2005-01-20 08:47:55 Help in Replication
Previous Message Michael Fuhr 2005-01-20 08:02:01 Re: Privileges where not restored

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2005-01-20 08:07:24 Re: ECPG Segfaulting on EXEC SQL connect
Previous Message Tino Wildenhain 2005-01-20 07:34:30 Re: Unique Index