Re: Errors starting postgres after initializing new database

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Errors starting postgres after initializing new database
Дата
Msg-id 4BD7B8FF.2070801@2ndquadrant.com
обсуждение исходный текст
Ответ на Errors starting postgres after initializing new database  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Список 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@2ndQuadrant.com   www.2ndQuadrant.us



В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Server Panic when trying to stop point in timerecovery
Следующее
От: Greg Smith
Дата:
Сообщение: Re: VACUUM FULL vs backup/restore