Accessing PostgreSQL Database Crashes Server

From: bradjwilkins(at)netscape(dot)net
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Accessing PostgreSQL Database Crashes Server
Date: 2002-04-23 22:29:01
Message-ID: 41702202.0E6223FB.6DD2E8F8@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 outputs the 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(at)Netscape! http://shopnow.netscape.com/

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

Browse pgsql-cygwin by date

  From Date Subject
Next Message bradjwilkins 2002-04-23 22:48:48 Accessing PostgreSQL Database Crashes Server
Previous Message Robert J. Sanford, Jr. 2002-04-23 22:13:11 client authentication protocols?