I copied the sample config file to postgresql workign directory before trying to start postgresql: # pwd /usr/local/share/postgresql twp1:postgresql # cp postgresql.conf.sample ../../pgsql/data/postgresql.conf On Fri, Jun 26, 2009 at 4:04 PM, Sam Wun<swun2010@xxxxxxxxx> wrote: > 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
