| 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: | Whole Thread | Raw Message | 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 |