Re: Fatal: 2149478 (UNCLASSIFIED)

>
>         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/