Postgres Pro
Downloads
Home   >   mailing lists

Thread: shmget problem with Win NT services

shmget problem with Win NT services

From
Kenéz Attila
Date:
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

Re: shmget problem with Win NT services

From
Jason Tishler
Date:
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

Re: shmget problem with Win NT services

From
"Victor H. Hdz. Posadas"
Date:
first of all, excuse my bad english, i am not native
speaker, i am working wit pgsql (currently 7.3.2) on
Win 2000 Pro using cygwin.

I sugest you read
/usr/doc/Cygwin/postgresql-7.X.X.README, wich one
explain each software package neded for pgsql, may be
the problem is your cygipc package, wich *most* to be
1.13-2 or later for pgsql 7.3.X.

cheers

Victor H. Hdz. Posadas

_________________________________________________________
Do You Yahoo!?
La mejor conexión a internet y 25MB extra a tu correo por $100 al mes. http://net.yahoo.com.mx