Re: PG 7.0.3 & RH 7 IPC problems?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PG 7.0.3 & RH 7 IPC problems?
Дата
Msg-id 22534.985882884@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PG 7.0.3 & RH 7 IPC problems?  (DHSC Webmaster <webmaster@dhs-club.com>)
Ответы Re: PG 7.0.3 & RH 7 IPC problems?  (Stefan Huber <schweinsaug@crosswinds.net>)
Список pgsql-admin
DHSC Webmaster <webmaster@dhs-club.com> writes:
> [postgres@atl01371 data]$ nohup postmaster -D /usr/local/pgsql/data -i
> -B 128 -N 64 > /usr/local/pgsql/data/logs/log.txt
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=2048000, permission=600

Not sure about Linux, but on HPUX there are two possible reasons for
shmget to return EINVAL:

          [EINVAL]       size is less than the system-imposed minimum or
                         greater than the system-imposed maximum.

          [EINVAL]       A shared memory identifier exists for key but the
                         size of the segment associated with it is less
                         than size and size is not equal to zero.

In other words, you could get this if there is an old segment of smaller
size and the same key still laying about, which there might well be if
you were foolish enough to kill -9 the old postmaster.  Use ipcs and
ipcrm to check and clean up.

7.1 uses a slightly different approach that hopefully avoids this
particular failure scenario...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Please Help Can not connect to any database
Следующее
От: Stefan Huber
Дата:
Сообщение: Re: PG 7.0.3 & RH 7 IPC problems?