pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Fatal: 2149478 (UNCLASSIFIED)
5+ messages / 5 participants
[nested] [flat]

* Fatal: 2149478 (UNCLASSIFIED)
@ 2006-05-11 15:26 Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
  2006-05-11 15:51 ` Re: Fatal: 2149478 (UNCLASSIFIED) Alvaro Herrera <alvherre@commandprompt.com>
  2006-05-11 16:07 ` Re: Fatal: 2149478 (UNCLASSIFIED) Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Crowson, Sarah J Ms (Contractor) Northrop Grumman @ 2006-05-11 15:26 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Fatal: 2149478 (UNCLASSIFIED)
  2006-05-11 15:26 Fatal: 2149478 (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
@ 2006-05-11 15:51 ` Alvaro Herrera <alvherre@commandprompt.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Alvaro Herrera @ 2006-05-11 15:51 UTC (permalink / raw)
  To: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>; +Cc: pgsql-admin

Crowson, Sarah J Ms (Contractor) Northrop Grumman wrote:

> 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" ............

Valid values for that parameter is INT_MAX / 1024.  INT_MAX is defined
here as 

$ grep 'define.* INT_MAX' /usr/include/limits.h 
#  define INT_MAX       2147483647

So that puts the maximum at 2097151, which you are exceeding.  This
assume your platform is similar to mine (size_t == 4 bytes).

$ dc
2147483647 1024 / p
2097151

Note the size is measured in kilobytes.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Fatal: 2149478 (UNCLASSIFIED)
  2006-05-11 15:26 Fatal: 2149478 (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
@ 2006-05-11 16:07 ` Joshua D. Drake <jd@commandprompt.com>
  2006-05-11 17:28   ` Re: Fatal: 2149478 (UNCLASSIFIED) Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 5+ messages in thread

From: Joshua D. Drake @ 2006-05-11 16:07 UTC (permalink / raw)
  To: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>; +Cc: pgsql-admin

> 
>         Fatal:  2149478 is outside the valid range for parameter 
> "maintenance_work_mem" ............

That is odd. I just testing on 8.1.3:

template1=# set maintenance_work_mem = 2149478;
SET
template1=#

Oh wait.. duh! :)... Remember that maintenance_work_mem is in "k". The 
max you are going to be able to do is: 2147483647. Your number equates 
to: 2201065472

Sincerely,

Joshua D. Drake

-- 

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Fatal: 2149478 (UNCLASSIFIED)
  2006-05-11 15:26 Fatal: 2149478 (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
  2006-05-11 16:07 ` Re: Fatal: 2149478 (UNCLASSIFIED) Joshua D. Drake <jd@commandprompt.com>
@ 2006-05-11 17:28   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Tom Lane @ 2006-05-11 17:28 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>; pgsql-admin

"Joshua D. Drake" <jd@commandprompt.com> writes:
>> Fatal:  2149478 is outside the valid range for parameter 
>> "maintenance_work_mem" ............

> That is odd. I just testing on 8.1.3:

> template1=# set maintenance_work_mem = 2149478;
> SET

I'm betting Joshua is testing on a 64-bit machine.  Since 8.1, the max
allowed value is dependent on sizeof(pointer) ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Fatal: 2149478 (UNCLASSIFIED)
@ 2006-05-11 15:29 mcelroy, tim <tim.mcelroy@bostonstock.com>
  0 siblings, 0 replies; 5+ messages in thread

From: mcelroy, tim @ 2006-05-11 15:29 UTC (permalink / raw)
  To: 'Crowson, Sarah J Ms (Contractor) Northrop Grumman' <Sarah.Crowson@us.army.mil>; pgsql-admin

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 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-05-11 17:28 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-11 15:26 Fatal: 2149478 (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
2006-05-11 15:51 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-05-11 16:07 ` Joshua D. Drake <jd@commandprompt.com>
2006-05-11 17:28   ` Tom Lane <tgl@sss.pgh.pa.us>
2006-05-11 15:29 Re: Fatal: 2149478 (UNCLASSIFIED) mcelroy, tim <tim.mcelroy@bostonstock.com>

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