Re: Fatal: 2149478 (UNCLASSIFIED) - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Fatal: 2149478 (UNCLASSIFIED)
Date
Msg-id 4463613F.2020009@commandprompt.com
Whole thread Raw
In response to Fatal: 2149478 (UNCLASSIFIED)  ("Crowson, Sarah J Ms (Contractor) Northrop Grumman" <Sarah.Crowson@us.army.mil>)
Responses Re: Fatal: 2149478 (UNCLASSIFIED)
List 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/



pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fatal: 2149478 (UNCLASSIFIED)
Next
From: "Jim C. Nasby"
Date:
Subject: Re: trobles in importing dbf file