Re: - Server gives error when I run the sql query - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: - Server gives error when I run the sql query
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMEAGHFAA.nickf@ontko.com
Whole thread Raw
In response to - Server gives error when I run the sql query  ("sriharsha@aworkflow.com" <sriharsha@aworkflow.com>)
List pgsql-admin
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).


pgsql-admin by date:

Previous
From: "sriharsha@aworkflow.com"
Date:
Subject: - Server gives error when I run the sql query
Next
From: "Nick Fankhauser"
Date:
Subject: Re: How to recover error message at boot time?