[ADMIN] Database recovery due to out of disk space

2009-10-01 Thread M4N - Dennis Brouwer
While implementing a warm standby server lightning struck, the WAL files supposed to be shipped to the warm standby server caused the filing system to be out of disk space. In order to quickly reclaim disk space we removed some of the WAL files written to pg_xlogs (very stupid we know). A corru

Re: [ADMIN] Database recovery due to out of disk space

2009-10-01 Thread Tom Lane
M4N - Dennis Brouwer writes: > We are trying to recover this database on a different server and > re-indexed all (but one) tables, only one -unimportant- table refuses to > be re-indexed or even dropped. We desperately want to drop this single > table (it's recreated constantly) but we can not