Troubles with WAL and pg_control

Поиск
Список
Период
Сортировка
От Rasmus Mohr
Тема Troubles with WAL and pg_control
Дата
Msg-id 910513A5A944D5118BE900C04F67CB5A0BFD75@MAIL
обсуждение исходный текст
Ответы Re: Troubles with WAL and pg_control
Список pgsql-admin
Hi, we have serious problem with our postgresql db.

A staling query were killed and all the WAL files were deleted. Afterwards
any attempts to restart postmaster fails, probably due to missing links from
pg_control to the WAL files.

How do we solve this problem? Erasing all lines in pg_control did not
help...

--------------------------------------------------------------
Rasmus T. Mohr            Direct  :             +45 36 910 122
Application Developer     Mobile  :             +45 28 731 827
Netpointers Intl. ApS     Phone   :             +45 70 117 117
Vestergade 18 B           Fax     :             +45 70 115 115
1456 Copenhagen K         Email   : mailto:rmo@netpointers.com
Denmark                   Website : http://www.netpointers.com

"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------

В списке pgsql-admin по дате отправления:

Предыдущее
От: Aaron Spiteri
Дата:
Сообщение: upgrade on debian
Следующее
От: Rasmus Mohr
Дата:
Сообщение: Re: Troubles with WAL and pg_control