Thread: Starting Error

Starting Error

From
"Muhyiddin A.M Hayat"
Date:
 
$ postmaster -D /usr/share/postgresql/data/ -i
IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not enough cor
e
 
This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 1499136 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).
 
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

Re: Starting Error

From
Jason Tishler
Date:
Muhyiddin,

On Thu, Sep 18, 2003 at 04:54:59PM +0800, Muhyiddin A.M Hayat wrote:
> $ postmaster -D /usr/share/postgresql/data/ -i
> IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not
> enough core

Does the following from the README apply?

    2. It is recommended to delete all cygipc temporary files
    (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
    a different user account.  Otherwise, postmaster will fail to start
    due to IPC errors.  Note cygipc 2.x automatically removes these
    files during normal shutdown so this issue has been essentially
    obviated.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6