Re: start error - pgsql - Mailing list pgsql-general

From kanchana
Subject Re: start error - pgsql
Date
Msg-id 018801c2cde2$7ee51300$3b0110ac@kovaiteam.com
Whole thread Raw
In response to Re: start error - pgsql  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Responses Re: start error - pgsql  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Hello Niqel,

I started postgresql by tried with "postmaster -D data -N 16", now it is ok.

but i want to avoid this without using -N switch. (i.e i want to start
without -N)
is it possible? if so how.

thanks a lot for your efforts.

Regards,
-Kanchana


>
>
> Well what does:
>
> df -k
>
> and
>
> df -i
>
> tell you about disk usage, you're mostly interested in the partition the
> postgres data directory is in, although whatever /tmp is on may be
significant
> as well.
>
> Have you tried reducing the max_connections parameter in postgres.conf?
>
> --
> Nigel Andrews
>
>
> On Thu, 6 Feb 2003, kanchana wrote:
>
> > Hello all,
> >
> >
> > I treid to compile and install postgresql on PA-RISC.
> > it is insatlled , but while trying to start as
> > ./pg_ctl -D data -l logfile
> > i got following messages in logfile.
> >
> > plz tell me how to overcome this.
> >
> >
> > IpcSemaphoreCreate: semget(key=5432006, num=17, 03600) failed: No space
left on
> > device
> >
> > This error does *not* mean that you have run out of disk space.
> >
> > It occurs when either the system limit for the maximum number of
> > semaphore sets (SEMMNI), or the system wide maximum number of
> > semaphores (SEMMNS), would be exceeded.  You need to raise the
> > respective kernel parameter.  Alternatively, reduce PostgreSQL's
> > consumption of semaphores by reducing its max_connections parameter
> > (currently 32).
> >
> > The PostgreSQL Administrator's Guide contains more information about
> > configuring your system for PostgreSQL.
> >
> > Thanks and Regards,
> > -kanchana
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: "Alastair D'Silva"
Date:
Subject: OT: This list is Razored
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: start error - pgsql