Обсуждение: - 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/ .

The error message gave you most of the answer. Either increase the available
memory from the OS or decrease the two parameters mentioned. You can set
these in postgresql.conf Look here for details:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime-conf
ig.html

(BTW, the cheapest way to increase the RAM available is to use Linux instead
of Win2000 <grin>.)


> > 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).