Skip site navigation (1) Skip section navigation (2)

Re: Errors starting postgres after initializing new database

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-general by date

Next:From: Greg SmithDate: 2010-04-28 04:31:22
Subject: Re: VACUUM FULL vs backup/restore
Previous:From: Chris VelevitchDate: 2010-04-28 03:10:38
Subject: Is the wiki down?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group