Re: wal logging

Database recovery from write ahead logs is only supported in PostgreSQL
8.0.0 and later.

-----------------------------------------------------------------------
hi

I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the steps to be followed in postgres regarding logical
corruption, instance failures, block corruption, log corruption?

I am using postgres 7.3.9
I was checking out WAL logging. I enabled WAL logging in postgres.conf
I found the logs in the pg_xlog directory but don't know how to recover it

thanks,
kailash


:.________________
CONFIDENTIALITY : This  e-mail  and  any attachments are confidential and
may be privileged. If  you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly