Re: [ADMIN] wal logging

2005-06-17 Thread Bruno Wolff III
On Fri, Jun 17, 2005 at 14:09:53 +0100, Kailash Vyas <[EMAIL PROTECTED]> wrote: > thanks for the info. > what is the utility of WAL logging in postgres 7.3 It allows the postres to recover if the server crashes. ---(end of broadcast)--- TIP 7: do

Re: [ADMIN] wal logging

2005-06-17 Thread hubert depesz lubaczewski
On 6/17/05, Kailash Vyas <[EMAIL PROTECTED]> wrote: > for example in case of database crash what would be the steps involved in > recovering it through WAL. just restart the database. postgresql with recover itself using wal files. depesz ---(end of broadcast)---

Re: [ADMIN] wal logging

2005-06-17 Thread Kailash Vyas
thanks tom for you prompt response. can you give me more info into crash protection. for example in case of database crash what would be the steps involved in recovering it through WAL. thanks, kailash On 6/17/05, Tom Lane <[EMAIL PROTECTED]> wrote: Kailash Vyas <[EMAIL PROTECTED]> writes:> what is

Re: [ADMIN] wal logging

2005-06-17 Thread Tom Lane
Kailash Vyas <[EMAIL PROTECTED]> writes: > what is the utility of WAL logging in postgres 7.3 Crash protection. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www

Re: [ADMIN] wal logging

2005-06-17 Thread Kailash Vyas
thanks for the info. what is the utility of WAL logging in postgres 7.3 thanks, kailashOn 6/17/05, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:Database recovery from write ahead logs is only supported in PostgreSQL 8.0.0 and later.-

Re: [ADMIN] wal logging

2005-06-17 Thread thomas . revell
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 ste