bug - Mailing list pgsql-bugs

From Prian Subban
Subject bug
Date
Msg-id F5E29B391A2FC34C895C663A85613FE60347EE70@gam-exch-app.mdd.co.za
Whole thread Raw
List pgsql-bugs
Hi could you help me resolve the following when trying to start the DB.

$ ./postmaster -D /data1/pgdata
IpcMemoryCreate: shmget(key=3D5432001, size=3D1417216, 03600) failed: Inval=
id argume
nt

This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter.  You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 1417216 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).

If the request size is already small, it's possible that it is less than
your kernel's SHMMIN parameter, in which case raising the request size or
reconfiguring SHMMIN is called for.

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

$

pgsql-bugs by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Permissions problem with sequences
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Permissions problem with sequences