Thread: Memory problems on Windows XP

Memory problems on Windows XP

From
"George Weaver"
Date:
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
 
 

Re: Memory problems on Windows XP

From
Jason Tishler
Date:
George,

On Mon, Sep 23, 2002 at 05:48:27PM -0500, George Weaver wrote:
> IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough core

Did you recently switch the user that postmaster runs under?  If so,
then try the following:

    $ rm /tmp/cygipc* /tmp/MultiFile*

Otherwise, try the following:

    http://sources.redhat.com/ml/cygwin/2000-04/msg00267.html

Jason

Re: Memory problems on Windows XP

From
Jason Tishler
Date:
George,

Please keep your replies on-list.

On Mon, Sep 30, 2002 at 01:49:55PM -0500, George Weaver wrote:
> I tried the option you suggested without success.  Rather than editing
> the Registry File as suggested in the link provided, I reinstalled the
> Cygwin PostgreSQL package from scratch.  This time everything worked
> exactly as expected.

I'm glad that Cygwin PostgreSQL is working for you now.  However,
I don't understand how reinstalling should have solved your problem.

Jason