> 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.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
