Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B49D29FB39E; Mon, 26 Mar 2007 11:07:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 25816-06; Mon, 26 Mar 2007 11:07:37 -0300 (ADT) X-Greylist: delayed 01:36:12.039481 by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55]) by postgresql.org (Postfix) with ESMTP id 34BBE9FB368; Mon, 26 Mar 2007 11:07:42 -0300 (ADT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55] (may be forged)) by mailhost.ics.forth.gr (8.13.8/ICS-FORTH/V10-Server-2.0.0) with ESMTP id l2QCVSs8017338; Mon, 26 Mar 2007 15:31:28 +0300 Received: from sappho.ics.forth.gr (unknown [127.0.0.1]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id 2AB7916C061; Mon, 26 Mar 2007 15:31:28 +0300 (EEST) X-AuditID: 7f000001-aad9fbb00000050a-3e-4607bd1f4e53 Received: from SHADOWFAX (unknown [139.91.183.33]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id 55F808E40FC; Mon, 26 Mar 2007 15:31:27 +0300 (EEST) From: "Sorin N. Ciolofan" To: Cc: , Subject: ERROR: out of shared memory Date: Mon, 26 Mar 2007 15:32:08 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01C76FBB.EA3640A0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 thread-index: AcdvosTM0Er21xsKTJu5Z+iMXGS6Hg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Message-Id: <20070326123127.55F808E40FC@mailhost.ics.forth.gr> X-Brightmail-Tracker: AAAAAA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/217 X-Sequence-Number: 25041 This is a multi-part message in MIME format. ------=_NextPart_000_0045_01C76FBB.EA3640A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello! I have to manage an application written in java which call another module written in java which uses Postgre DBMS in a Linux environment. I'm new to Postgres. The problem is that for large amounts of data the application throws an: org.postgresql.util.PSQLException: ERROR: out of shared memory Please, have you any idea why this error appears and what can I do in order to fix this? Are there some Postgre related parameters I should tune (if yes what parameters) or is something related to the Linux OS? Thank you very much With best regards, Sorin ------=_NextPart_000_0045_01C76FBB.EA3640A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

    = Hello!

 

   I have to manage an application = written in java which call another module written in java which uses Postgre = DBMS in a Linux environment. I’m new to Postgres. The problem is that for = large amounts of data the application throws an:

 org.postgresql.util.PSQLException: = ERROR: out of shared memory

 

Please, have you any idea why this error = appears and what can I do in order to fix this?

Are there some Postgre related parameters I = should tune (if yes what parameters) or is something related to the Linux = OS?

 

Thank you very = much

With best = regards,

Sorin

------=_NextPart_000_0045_01C76FBB.EA3640A0--