Can't start postgresql 8.3.7

From: Sam Wun <swun2010(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't start postgresql 8.3.7
Date: 2009-06-26 06:04:12
Message-ID: 736c47cb0906252304t27481bd1w8890a29f80f2ef9c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Wun 2009-06-26 06:05:52 Re: Can't start postgresql 8.3.7
Previous Message Richard Huxton 2009-06-26 05:41:54 Re: Problems with postgres online backup - restore