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
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 |