Troubles with WAL and pg_control - Mailing list pgsql-admin

From Rasmus Mohr
Subject Troubles with WAL and pg_control
Date
Msg-id 910513A5A944D5118BE900C04F67CB5A0BFD75@MAIL
Whole thread Raw
Responses Re: Troubles with WAL and pg_control  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Aaron Spiteri
Date:
Subject: upgrade on debian
Next
From: Rasmus Mohr
Date:
Subject: Re: Troubles with WAL and pg_control