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

Поиск
Список
Период
Сортировка
От Marty Scholes
Тема Re: Oracle and Postgresql Play Nice Together on Same Computer?
Дата
Msg-id 41EFDD9A.5060600@outputservices.com
обсуждение исходный текст
Ответ на Oracle and Postgresql Play Nice Together on Same Computer?  ("Troyston Campano" <troygeekdatabase@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Oracle and Postgresql Play Nice Together on Same
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [ADMIN] Oracle and Postgresql Play Nice Together on