[GENERAL] corrupt data from invalid recovery

2014-07-30 Thread CS_DBA
We are trying to help a client, one of their databases was being backed up via snapshots without running a pg_start_backup or pg_stop _backup Recently they had an issue and they recovered from one of these snapshot backups, which are now producing errors such as : Invalid page header in block X

Re: [GENERAL] corrupt data

2003-07-11 Thread Alvaro Herrera
On Fri, Jul 11, 2003 at 09:32:12AM +0200, Zeno R.R. Davatz wrote: > Out of some reason our data of our postgresql database has been corrupted. When we > try to connect to the database we get: > > psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index: > No such file or directory >

[GENERAL] corrupt data

2003-07-11 Thread Zeno R.R. Davatz
Hi List Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get: psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index: No such file or directory REINDEX does not work. We get the same error. pgfsck gives us: wro