X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BFB529FA2F8 for ; Thu, 11 May 2006 12:35:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26139-10 for ; Thu, 11 May 2006 12:35:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from morpheus.bostonstock.com (morpheus.bostonstock.com [192.233.205.44]) by postgresql.org (Postfix) with ESMTP id 6A21F9F9430 for ; Thu, 11 May 2006 12:34:59 -0300 (ADT) Received: by MORPHEUS with Internet Mail Service (5.5.2653.19) id <2R02C7K4>; Thu, 11 May 2006 11:29:43 -0400 Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS> From: "mcelroy, tim" To: "'Crowson, Sarah J Ms (Contractor) Northrop Grumman'" , "'pgsql-admin@postgresql.org'" Subject: Re: Fatal: 2149478 (UNCLASSIFIED) Date: Thu, 11 May 2006 11:29:43 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6750F.5ADB96DC" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/142 X-Sequence-Number: 21674 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C6750F.5ADB96DC Content-Type: text/plain Not sure what type of system you are running postgres on but that error may mean that you have to bump up the SHMMAX setting in the kernel. In Linux it is set in the file /etc/sysctl.conf and in UNIX it is set in the file /etc/system. I know in Linux you can do it online with an echo command but not sure about UNIX. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Crowson, Sarah J Ms (Contractor) Northrop Grumman Sent: Thursday, May 11, 2006 11:26 AM To: 'pgsql-admin@postgresql.org' Subject: [ADMIN] Fatal: 2149478 (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hello - I am trying to set up my postgresql.conf file for Postgres 8.1. I am setting up the maintenance_work_mem (this has also happened with the work_mem) and I receive this error: Fatal: 2149478 is outside the valid range for parameter "maintenance_work_mem" ............ I have been working with Postgres since at least version 7.0 if not longer and I have never seen this error before. I have tried searching through the web a bit to see if I could find out any information for why my maintenance_work_mem is out of range, but as of yet I have not found any. Can anyone help me?? Sarah Crowson Classification: UNCLASSIFIED Caveats: NONE ------_=_NextPart_001_01C6750F.5ADB96DC Content-Type: text/html Content-Transfer-Encoding: quoted-printable Fatal: 2149478 (UNCLASSIFIED)

N= ot sure what type of system you are running postgres on but that error may mean = that you have to bump up the SHMMAX setting in the kernel.  In Linux it is set in the file /etc/sysctl.conf and = in UNIX it is set in the file /etc/system. I know in Linux you can do it online = with an echo command but not sure about = UNIX.

<= ![if = !supportEmptyParas]> 

=

<= ![if = !supportEmptyParas]> 

=

-----Original Message-----
From: = pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Crowson, Sarah J Ms (Contractor) Northrop = Grumman
Sent: Thursday, May 11, = 2006 11:26 AM
To: = 'pgsql-admin@postgresql.org'
Subject: [ADMIN] Fatal: = 2149478 (UNCLASSIFIED)

 

Classification:= UNCLASSIFIED
Caveats: NONE

Hello = - =

 =

I am trying to = set up my postgresql.conf file for Postgres 8.1.   I am setting up the maintenance_work_mem (this has also happened with the work_mem) and I = receive this error:

     &nb= sp;  Fatal:  2149478 is outside the = valid range for parameter "maintenance_work_mem" = ............ =

I have been = working with Postgres since at least version 7.0 if not longer and I have never seen = this error before.  I have tried searching through the web a bit to see = if I could find out any information for why my maintenance_work_mem is out = of range, but as of yet I have not found any.  Can anyone help = me??=

Sarah = Crowson
Classification: = UNCLASSIFIED
Caveats: NONE

------_=_NextPart_001_01C6750F.5ADB96DC--