Problems Starting Postgres as a Service

From: Nick Stone <nick(dot)stone(at)digitalvision(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Problems Starting Postgres as a Service
Date: 2003-09-03 08:57:24
Message-ID: 8193F6FD86EFD411BA9200300503320202595B81@UKMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I am trying to run Postgres on Windows as a service and after a bit of
playing around I can run it from within Cygwin and I can install it as a
service OK but when I try to start the service I get the following error:

> 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 have followed all the various how-to's / faq notes etc. and I realise that
the error message has some clues as to a possible solution but could someone
explain why I can start Postgres from the command prompt but not as a
service? Also what are the effects of reducing some of the parameters
mentioned in the error message?

Many thanks

Nick

Browse pgsql-admin by date

  From Date Subject
Next Message hugo_rousse 2003-09-03 12:25:09 Re: postgresql and replication
Previous Message Ian Barwick 2003-09-03 07:42:56 Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!