Re: Can't start postgresql 8.3.7

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

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(at)gmail(dot)com> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Knut P. Lehre 2009-06-26 08:26:40 PL/pgSQL EXECUTE quote_ident(), and SQL injection
Previous Message Sam Wun 2009-06-26 06:04:12 Can't start postgresql 8.3.7