| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
| Cc: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Errors starting postgres after initializing new database |
| Date: | 2010-04-28 04:26:39 |
| Message-ID: | 4BD7B8FF.2070801@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Chris Barnes wrote:
> 2010-04-27 16:19:17 EDT FATAL: requested shared memory size
> overflows size_t
This is what happens if you try and use a postgresql.conf with
parameters set for a 64-bit installation on a 32-bit operating system.
You're trying to do this:
shared_buffers = 7680MB
But the 32-bit Centos 5.2 you're using doesn't allow you to allocate
more than 2GB of RAM for that. If there really is around 32GB of RAM in
there, like I'm assuming the 5.4 system has for pgtune to made this
suggestion, you certainly will need to install a 64-it OS on it to take
advantage of that usefully.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-04-28 04:31:22 | Re: VACUUM FULL vs backup/restore |
| Previous Message | Chris Velevitch | 2010-04-28 03:10:38 | Is the wiki down? |