Re: start error - pgsql

Hi,

On Thu, 2003-02-06 at 12:12, kanchana wrote:

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

Maybe you should read this:

http://www.ca.postgresql.org/docs/faq-english.html#3.4

It tells what you should do.

Best regards,
--
Devrim GUNDUZ
TR.NET System Support Specialist

Tel : (312) 295 93 18 Fax : (312) 295 94 94 Tel : (216) 542 90 00

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:

On 6 Feb 2003, Devrim GUNDUZ wrote:

Hi,

On Thu, 2003-02-06 at 12:12, kanchana wrote:

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

Maybe you should read this:

http://www.ca.postgresql.org/docs/faq-english.html#3.4

It tells what you should do.

And maybe I should _read_ the error message before posting a reply. D'oh.

--
Nigel J. Andrews

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

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