Re: shmget problem with Win NT services

Hi!

I installed a Postgres server under Cygwin on a Windows Small Business
server. I installed the db server to run as a service, but if I configure
the service to run normal, as LocalSystem, it gives the next error message:

IpcMemoryCreate: shmget(key=5432001, size=1441792, 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 1441792 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.

If it runs as Administrator, it works fine. It also gives the same error
message if it runs as any other user (except Administrator). (I installed
the cygwin and the Postgres as Administrator if it counts, but I start the
ipc-daemon in the same process - so with the same user - as the Postgres
server.)

If somebody knows what is wrong, please write me!

Thanks:
Attila Kenez

Attila,

On Tue, Feb 18, 2003 at 07:00:49AM +0100, Kenéz Attila wrote:
> IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not
> enough core

Check the following permissions:

$ ls -l /tmp/MultiFile*
-rw-rw-rw- 1 SYSTEM SYSTEM 3916520 Jan 17 11:19 /tmp/MultiFileMsg
-rw-rw-rw- 1 SYSTEM SYSTEM 22032 Jan 17 11:19 /tmp/MultiFileSem
-rw-rw-rw- 1 SYSTEM SYSTEM 202768 Jan 17 11:19 /tmp/MultiFileShm

If the above files are not accessible by all, then you will have the
above mentioned problem.

Try deleting them:

$ rm -f /tmp/MultiFile*

and then restart the ipc-daemon as an NT service.

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