- 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  ("Nick Fankhauser" <nickf@ontko.com>)
Список 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 по дате отправления:

Предыдущее
От: Markus Bertheau
Дата:
Сообщение: Re: How to recover error message at boot time?
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: - Server gives error when I run the sql query