- Server gives error when I run the sql query

Hi

> I am facing the problem when I run any sql query
>
> 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.
>
> --------
>
> can you tell how to solve this problem. i am running
> the postgresql on win 2000

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .