pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFatal: 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>
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: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
* Re: Fatal: 2149478 (UNCLASSIFIED)
@ 2006-05-11 15:51 Alvaro Herrera <alvherre@commandprompt.com>
parent: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
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 16:07 Joshua D. Drake <jd@commandprompt.com>
parent: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
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 17:28 Tom Lane <tgl@sss.pgh.pa.us>
parent: Joshua D. Drake <jd@commandprompt.com>
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
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