Re: start error - pgsql

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: kanchana <pkkanchana(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: start error - pgsql
Date: 2003-02-06 14:06:30
Message-ID: Pine.LNX.4.21.0302061401270.20150-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


The simple solution if 16 is enough for you is to edit the max_connections
parameter in $PGDATA/postgres.conf By default it is 32 so change it to 16.

However, your system could be low on resources and you may just be delaying
the problems. I don't know if HP-UX gives something like sysctl, if so try and
find out about what and how it let's you change in the kernel
configuration. Alternatively, someone else already mentioned using SAM. You
should be able to change kernel settings through that tool. You do need root
priviledges to change the kernel though.

Good luck,

Nigel Andrews

On Thu, 6 Feb 2003, kanchana wrote:

> 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
> > >
>

--
Nigel J. Andrews

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jules Alberts 2003-02-06 14:08:17 how to determine OID of the row I just inserted???
Previous Message kanchana 2003-02-06 13:20:12 Re: start error - pgsql