| From: | Rasmus Mohr <rmo(at)Netpointers(dot)com> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Troubles with WAL and pg_control |
| Date: | 2002-04-24 10:43:37 |
| Message-ID: | 910513A5A944D5118BE900C04F67CB5A0BFD75@MAIL |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)netpointers(dot)com
Denmark Website : http://www.netpointers.com
"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rasmus Mohr | 2002-04-24 11:56:19 | Re: Troubles with WAL and pg_control |
| Previous Message | Mr OCP | 2002-04-24 05:52:57 | benchmarking tools |