help for database recovery!

[Anon]

who can tell me something about database recovery for postgresql. the manual page doesn\'t have it! thank you !!

[[deleted]]

DO you mean recorvery as in "my server exploded, I have no backup, help!"
or "I want to create a backup in case my server explodes"

[Anon]

i want to know if my sever exploded because of system failure or data base destruction etc. what can i do to recover it but not to drop all tables and recreate them with my backup. Is there any good method or utility for postgresql?

[[deleted]]

The thing is, once your database server exploded, you cannot trust ANY data that's on it, and you should really revert to backups.

Backups are not a luxury, they are a MUST.

In case of a database crash, where just the database engine stops abruptly,
Postgres supports a WAL (write ahead log). This will create a file on disk, containing all the queries required to update the update the tables to the state your tables were in just before the crash.

It is very important to let postgres do checkpoints and backups regularly.
Read the Postgre manual for more info about the WAL.

[Anon]

If it still can not recover the failure with WAL automatically , can I made any program to read info about the checkpoint and the system backups ? which book can i refer about it?

[[deleted]]

do a search on www.google.com