Re: Fatal: 2149478 (UNCLASSIFIED)

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Crowson, Sarah J Ms (Contractor) Northrop Grumman" <Sarah(dot)Crowson(at)us(dot)army(dot)mil>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fatal: 2149478 (UNCLASSIFIED)
Date: 2006-05-11 16:07:27
Message-ID: 4463613F.2020009@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-05-11 16:44:22 Re: trobles in importing dbf file
Previous Message Alvaro Herrera 2006-05-11 15:51:46 Re: Fatal: 2149478 (UNCLASSIFIED)