- Server gives error when I run the sql query
От | sriharsha@aworkflow.com |
---|---|
Тема | - Server gives error when I run the sql query |
Дата | |
Msg-id | 191690-22003504125851340@M2W050.mail2web.com обсуждение исходный текст |
Ответы |
Re: - Server gives error when I run the sql query
|
Список | 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 по дате отправления: