Re: Oracle and PostgreSQL servers incompatibility - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Oracle and PostgreSQL servers incompatibility
Date
Msg-id 20031114144757.GB27483@libertyrms.info
Whole thread Raw
In response to Oracle and PostgreSQL servers incompatibility  ("Jouneau Luc" <Luc.Jouneau@diamant.jouy.inra.fr>)
List pgsql-admin
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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with compilation 7.3.4
Next
From: Tom Lane
Date:
Subject: Re: Oracle and PostgreSQL servers incompatibility