Обсуждение: Error raised whilst running Postgres as a service (Win2000 Pro)
Hi I have managed to get postmaster to start from Cygwin's command prompt and I have installed IPC-Deamon and started it as per insructions in the dob http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README. However when I try to start the postmaster service I get the following error in the postmaster log: > IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not enough core> > > > 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. I realise that to some extent the answer may lie in the error message but I have read other threads about Win 2003 and I wanted to make sure that I wasn't going down the wrong route by trying to adjust the parameters listed. Also could somebody explain why I get the error message as a service but not when postmaster is run as a separte program? Many thanks Nick ----------------------------------------------------- Nick Stone 161 Hare Lane home: +44 (0)1372 467902 Claygate mobile: +44 (0)7779 300857 Surrey eMail: nicks.email@bigfoot.com KT10 0RA UK
Nick, On Wed, Sep 03, 2003 at 08:29:02PM +0100, Nick Stone wrote: > > IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: > > Not enough core > > > > This error usually means that PostgreSQL's request for a shared > > memory segment exceeded available memory or swap space. > > [snip] > > I realise that to some extent the answer may lie in the error message > but I have read other threads about Win 2003 and I wanted to make sure > that I wasn't going down the wrong route by trying to adjust the > parameters listed. Adjusting the above parameter will have no affect under Cygwin. > Also could somebody explain why I get the error message as a service > but not when postmaster is run as a separte program? AFAICT, the solution is in the README's issues section: 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