From: | "George Weaver" <georgew1(at)mts(dot)net> |
---|---|
To: | <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Memory problems on Windows XP |
Date: | 2002-09-23 22:48:27 |
Message-ID: | 001b01c26353$55bc62c0$4d0fa18e@George |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I have recently installed Cygwin PostgreSQL using Windows XP. I have an 80 gb hard drive and 512 mb of RAM
I was able to successfully use Initdb, and seem to be able to start Postmaster, but when I try to use Createdb I keep getting the following message on the Server side:
bash-2.05b$ postmaster -D data -i
DEBUG: database system was interrupted at 2002-09-23 17:12:31 CST
DEBUG: checkpoint record is at 0/1135E8
DEBUG: redo record is at 0/1135E8; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/113628
DEBUG: redo is not required
DEBUG: database system is ready
DEBUG: server process (pid 220) exited with exit code 128
DEBUG: terminating any other active server processes
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
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.
and
bash-2.05b$ createdb -h localhost testdb
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.
createdb: database creation failed
on the client side.
I'm installed the following versions:
Cygwin 1.3.12-4
Postgresql 7.2.2-1.
I can't figure out how to resolve this.
George
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2002-09-24 11:55:02 | Re: PostgreSQL |
Previous Message | Hugo Escobar | 2002-09-23 19:47:55 | postgres stopped working after a reboot |