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

From sriharsha@aworkflow.com
Subject - Server gives error when I run the sql query
Date
Msg-id 191690-22003504125851340@M2W050.mail2web.com
Whole thread Raw
Responses Re: - Server gives error when I run the sql query
List pgsql-admin
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/ .


pgsql-admin by date:

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