[ADMIN] Corrupted database - how to recover

2010-05-27 Thread Johann Spies
After two disks on our raid-5 system failed causing a filesystem failure. We could get one online again and the filesystem is at present usable but I cannot start postgresql at the moment: $ /usr/lib/postgresql/8.3/bin/postgres --single -D /etc/postgresql/8.3/main/ 2010-05-27 09:22:48 SAST

Re: [ADMIN] Corrupted database - how to recover

2010-05-27 Thread Andreas Schmitz
hi johann, maybe you should consider using point in time recovery (pitr) if the database is mission critical. http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html regards andreas Johann Spies wrote: After two disks on our raid-5 system failed causing a filesystem

Re: [ADMIN] Corrupted database - how to recover

2010-05-27 Thread Johann Spies
On Thu, May 27, 2010 at 09:54:00AM +0200, Andreas Schmitz wrote: maybe you should consider using point in time recovery (pitr) if the database is mission critical. http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html Thanks. This is the first time I experienced this