Can't start postgresql 8.3.7

Поиск
Список
Период
Сортировка
От Sam Wun
Тема Can't start postgresql 8.3.7
Дата
Msg-id 736c47cb0906252304t27481bd1w8890a29f80f2ef9c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can't start postgresql 8.3.7  (Sam Wun <swun2010@gmail.com>)
Re: Can't start postgresql 8.3.7  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I had been running postgresql 8.3.7 in freebsd for some time, but
after I changed its postgresql.conf file, it can't start any more
eventhoguh I changed the config back to its original file.
Anything wrong?

Here is the errros:

Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL:  could not create
semaphores: No space left on device
Jun 26 15:58:52 twp1 postgres[1394]: [1-2] DETAIL:  Failed system call
was semget(5432004, 17, 03600).
Jun 26 15:58:52 twp1 postgres[1394]: [1-3] HINT:  This error does
*not* mean that you have run out of disk space.
Jun 26 15:58:52 twp1 postgres[1394]: [1-4]      It occurs when either
the system limit for the maximum number of semaphore sets (SEMMNI), or
the system wide maximum number of
Jun 26 15:58:52 twp1 postgres[1394]: [1-5]  semaphores (SEMMNS), would
be exceeded.  You need to raise the respective kernel parameter.
Alternatively, reduce PostgreSQL's
Jun 26 15:58:52 twp1 postgres[1394]: [1-6]  consumption of semaphores
by reducing its max_connections parameter (currently 103).
Jun 26 15:58:52 twp1 postgres[1394]: [1-7]      The PostgreSQL
documentation contains more information about configuring your system
for PostgreSQL.

Very appreciate for any suggestion.
Thanks

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Problems with postgres online backup - restore
Следующее
От: Sam Wun
Дата:
Сообщение: Re: Can't start postgresql 8.3.7