Re: shmget problem with Win NT services

From: Justin Clift <justin(at)postgresql(dot)org>
To: akenez(at)energo-szoft(dot)hu
Cc: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: shmget problem with Win NT services
Date: 2003-02-17 22:57:47
Message-ID: 3E5168EB.7000007@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-17 23:29:34 Re: pg_dump --> restore loses constraints/triggers?
Previous Message Tony Grant 2003-02-17 22:55:56 Re: accent = no accent