pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mcelroy, tim <tim.mcelroy@bostonstock.com>
To: 'Crowson, Sarah J Ms (Contractor) Northrop Grumman' <Sarah.Crowson@us.army.mil>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Fatal: 2149478 (UNCLASSIFIED)
Date: Thu, 11 May 2006 11:29:43 -0400
Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS> (raw)

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 

view thread (5+ messages)  latest in thread

Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS>
Permalink:  ../0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS/
Also on:    postgresql.org/message-id/0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tim.mcelroy@bostonstock.com, Sarah.Crowson@us.army.mil
  Subject: Re: Fatal: 2149478 (UNCLASSIFIED)
  In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS>
  References: <0C4841B42F87D51195BD00B0D020F5CB044B2656@MORPHEUS>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox