Re: Oracle and Postgresql Play Nice Together on Same Computer? - Mailing list pgsql-general

From Marty Scholes
Subject Re: Oracle and Postgresql Play Nice Together on Same Computer?
Date
Msg-id 41EFDD9A.5060600@outputservices.com
Whole thread Raw
In response to Oracle and Postgresql Play Nice Together on Same Computer?  ("Troyston Campano" <troygeekdatabase@gmail.com>)
List pgsql-general
 > 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.

We currently run Oracle and Pg 7.4.6 in production on a Solaris 8 box
with no problems.  The only concern we have had is with the freakiness
of the /etc/system message queue, semaphore and shared memory settings.
  Several apps seem to consume these finite resources and most of them
quietly act strangely and lose data when these resources are depleted.
Very few applications document what resources they *really* need.

There is probably a slick way to monitor these settings and determine
the right numbers for these, but we have not found it.  Right now the
technique is "set, boot and pray."

BTW, concern with these resources is the sole reason we are hesitant to
install a slave server running 8.0 so that we can migrate.  We will be
on 7.4 for some time.

Other than that, we have had no problems with running both Oracle and Pg
together on a production machine.


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Oracle and Postgresql Play Nice Together on Same
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on