Received: from trends.net (clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA01786 for ; Wed, 1 Dec 1999 10:01:56 -0500 (EST) (envelope-from awilliam@whitemice.org) From: awilliam@whitemice.org Received: from estate1.whitemice.org (root@64-50.pop.gr.mi.verio.com [209.69.64.50] (may be forged)) by trends.net (8.8.8/8.8.8) with ESMTP id HAA19321 for ; Wed, 1 Dec 1999 07:07:23 -0500 (EST) Received: from estate1.whitemice.org (IDENT:awilliam@localhost [127.0.0.1]) by estate1.whitemice.org (8.9.3/8.9.3) with SMTP id HAA13354; Wed, 1 Dec 1999 07:09:59 -0500 Date: Wed, 01 Dec 1999 12:09:59 GMT Message-ID: <19991201.12095900@estate1.whitemice.org> Subject: Re: [INTERFACES] Too many private FDs To: Rolf =?ISO-8859-1?Q?L=FCttecke?= CC: pgsql-interfaces@postgresql.org In-Reply-To: <3844DF65.FF29CA5A@gcd.de> References: <3844DF65.FF29CA5A@gcd.de> X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.1; Linux) X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id KAC03124 > -- ERROR: AllocateFile: too many private FDs demanded > -- pq_recvbuf: unexpected EOF on client connection > -- IpcMemoryCreate: shmget failed (Identifier removed) key=5432007, > size=96424, permission=600 > -- SISegmentGet: failed: Identifier removed > -- FATAL 1: CreateSharedInvalidationState: failed segment init > -- FATAL 1: AttachSLockMemory: could not attach segment > A few environment information: > PostgreSQL 6.5.2 w/ SuSE 6.0 (2.0.36) running on a SNI-Primergy 070 > Access-method: w/ Insight's ODBC-driver (6.5/0006) from MS-Access I have had similair problems with the Informix Online database engine. You need to be running a 2.2.x kernel and to use the sysctrl interface to increase the number of file handles (by default limited to 1024) and possibly the maximum shared memory size.