Re: shmget problem with Win NT services - Mailing list pgsql-general

From Justin Clift
Subject Re: shmget problem with Win NT services
Date
Msg-id 3E5168EB.7000007@postgresql.org
Whole thread Raw
In response to shmget problem with Win NT services  (Kenéz Attila <akenez@energo-szoft.hu>)
List pgsql-general
Hi Attila,

Probably the best place to ask is on the PostgreSQL "Cygwin" mailing
list, as the people there specialise in Cygwin/Windows knowledge.  Much
of the PostgreSQL Community has stronger knowledge of non-Windows
environments.

You can join that mailing list by going to:

http://developer.postgresql.org/mailsub.php

Hope that helps.

Regards and best wishes,

Justin Clift


Kenéz Attila wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


pgsql-general by date:

Previous
From: Patrick Nelson
Date:
Subject: Re: RE in where [SOLVED]
Next
From: Tom Lane
Date:
Subject: Re: pg_dump --> restore loses constraints/triggers?