shared_buffers vs. -B flag: 7.4

Поиск
Список
Период
Сортировка
От elein@varlena.com (elein)
Тема shared_buffers vs. -B flag: 7.4
Дата
Msg-id 20050123183827.GP15269@varlena.com
обсуждение исходный текст
Ответы Re: shared_buffers vs. -B flag: 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
This was reproduced on 7.4. I don't know
if it is still an issue on 8.0.

If you set shared_buffers (shmem_max)
to greater than the shmem config on the
OS pg will not start.  And gives a useful
message (below).

However, if you use the -B option on the pg_ctl
start up, postgres starts up fine.  And
the shared_buffers value shown by show
is the higher value.

These options should work the same.

--elein
elein@varlena.com


waiting for postmaster to start...2005-01-04 01:20:09 [45468]
FATAL:could not create shared memory segment: Invalid argument

DETAIL:  Failed system call was shmget(key=2010001, size=555876352, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter.  You can either reduce the
request size or reconfigure the kernel with larger SHMMAX.  To reduce the
request size (currently 555876352 bytes), reduce PostgreSQL's shared_buffers
parameter (currently 65535) and/or its max_connections parameter (currently 138).

If the request size is already small, it's possible that it is
less than your kernel's SHMMIN parameter, in which case raising the
request size or reconfiguring SHMMIN is called for.

The PostgreSQL documentation contains more information
about shared memory configuration.

.............................................................failed
pg_ctl: postmaster does not start

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: inconsitent tab completion in psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: shared_buffers vs. -B flag: 7.4