EDoc DB Restore HowTo

MPDL

In case of bad crushed eDoc posgtres DB (the postgres cannot be correctly started anymore), the restore procedure should be following:

Postgres DB restore sequence (till current Monday inclusive)
tar xfvz /X/backup/pgsql/backup/pgdata-.tar.gz cp /X/backup/pgsql/logs/* /X/backup/pgsql/backup/data/ restore_command = 'cp /var/lib/pgsql/logs/%f %p' recovery_target_time = '2008-11-25 18:08:06' rcpostgresql start if the DB starts, it will be restored until the timestamp 2008-11-25 18:08:06
 * unzip the backup
 * copy the Log-Files from the saved xlog drectory (pg_xlog) into the /X/backup/pgsql/backup/ directory
 * create a file  in the
 * start DB

Postgres DB restore sequence (8 weeks older than current Monday)

 * take the backup/log files from the  directories
 * old: 4 weeks preceded the current Mondays
 * older: 4 weeks preceded the backups of old directory