Accessing PostgreSQL Database Crashes Server - Mailing list pgsql-cygwin

From bradjwilkins@netscape.net
Subject Accessing PostgreSQL Database Crashes Server
Date
Msg-id 13A857B6.3B0A4668.6DD2E8F8@netscape.net
Whole thread Raw
List pgsql-cygwin
I have the exact same problem that Alexei Tenitski has.

I have no problems initializing and starting the PostgreSQL database server (using postmaster or as an Windows
service).

However, as soon as I attempt to use the database (using make checkinstall or psql), the server crashes/stops and
outputsthe following error: 

>>>>>

ZeroProcSemaphore: semctl(id=0,SETVAL) failed: Invalid argument
DEBUG:  server process (pid 1108) exited with exit code 255
DEBUG:  terminating any other active server processes
DEBUG:  all server processes terminated; reinitializing shared memory and semaph
ores
IpcMemoryCreate: shmget(key=5432001, size=655360, 03600) failed: Not enough memo
ry

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 655360 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 16) and/or
its max_connections parameter (currently 8).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

<<<<<

I have played with shared_buffers and max_connections with no luck.

Has anyone figure out what the problem is?  All help is sincerely appreciated.

Thanks,
Brad Wilkins



__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with
Shop@Netscape!http://shopnow.netscape.com/ 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/


pgsql-cygwin by date:

Previous
From: bradjwilkins@netscape.net
Date:
Subject: Accessing PostgreSQL Database Crashes Server
Next
From: "Tomasz Krol"
Date:
Subject: subscribe