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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
