Re: Oracle and PostgreSQL servers incompatibility

On Fri, Nov 14, 2003 at 12:07:40PM +0100, Jouneau Luc wrote:

> 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.

Sure, it might be correctly configured according to those docs, but
neither of them can know about other programs' semaphore use. You
probably need more available semaphores from your kernel.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110