Re: Fatal: 2149478 (UNCLASSIFIED)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Crowson, Sarah J Ms (Contractor) Northrop Grumman" <Sarah(dot)Crowson(at)us(dot)army(dot)mil>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fatal: 2149478 (UNCLASSIFIED)
Date: 2006-05-11 17:28:46
Message-ID: 15695.1147368526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Crowson, Sarah J Ms (Contractor) Northrop Grumman 2006-05-11 17:39:22 Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED)
Previous Message Jim C. Nasby 2006-05-11 16:44:22 Re: trobles in importing dbf file