Sam Wun <swun2010@xxxxxxxxx> writes: > 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? > Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not create > semaphores: No space left on device Apparently you changed the config in such a way that it no longer recognizes the old set of semaphores as being ones it should recycle. You need to get rid of the old SysV semaphore set. The easy, foolproof way to do that is to reboot. If you can't reboot the machine, then use ipcs and ipcrm to clean up manually. If there's more than one Postgres running on the system, be sure not to zap the semaphores belonging to the other instances... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
