Re: wal logging - Mailing list pgsql-admin

From thomas.revell@powerconv.alstom.com
Subject Re: wal logging
Date
Msg-id OFB7D0D8D0.3CF355CD-ON80257023.003EDC8D-80257023.00400944@test.alstom.com
Whole thread Raw
In response to wal logging  (Kailash Vyas <kailash.vyas@gmail.com>)
Responses Re: wal logging
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Kailash Vyas
Date:
Subject: wal logging
Next
From: Kailash Vyas
Date:
Subject: Re: wal logging