Re: Oracle and PostgreSQL servers incompatibility

Tom Lane wrote:
> "Jouneau Luc" <Luc(dot)Jouneau(at)jouy(dot)inra(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073