Re: Oracle and PostgreSQL servers incompatibility

Tom Lane wrote:
> "Jouneau Luc" <Luc.Jouneau@jouy.inra.fr> writes:
> > We plan to install on a same Solaris server an Oracle8i and a PostgreSQL
> > 7.3.4 database.
> > During our impact tests, we encountered a situation where no more semaphore
> > was available for Oracle server (while we where bulk loading on postgreSQL
> > using copy statement. There was only one PG connection while there were many
> > on Oracle server).
> > I quote that our kernel configuration (semaphore and shared memory
> > parameters) had been previously correctly positionned as required in Oracle
> > and postgreSQL documentation.
>
> Obviously not.  I suspect you forgot to add up the semaphore
> requirements of each package ...

Also, we grab all semaphores we will need for max connections at startup
so we don't fail under load so that might have surprised you.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073