Accessing PostgreSQL Database Crashes Server
От | bradjwilkins@netscape.net |
---|---|
Тема | Accessing PostgreSQL Database Crashes Server |
Дата | |
Msg-id | 41702202.0E6223FB.6DD2E8F8@netscape.net обсуждение исходный текст |
Список | 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 по дате отправления: