X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 911DF52818 for ; Fri, 17 Jun 2005 12:09:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43668-10 for ; Fri, 17 Jun 2005 15:09:01 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by svr1.postgresql.org (Postfix) with ESMTP id 55AB652809 for ; Fri, 17 Jun 2005 12:09:00 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 37so1148268wra for ; Fri, 17 Jun 2005 08:08:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=EdYFDzin12KZnmz+hABl6wProd5jg7twIlIvjaQy2nGISuXZuLP81dKAsTpKPDqZTeZakyPA2Q3RA9g6Wr5uGjBtJLPewUG0y1AVEfswt/xAyxbv8liOCvoMYyCsxHbC4SagDnrfDoXQrqBcSKQq96j9egXqtefM20RrOeBj3pw= Received: by 10.54.25.75 with SMTP id 75mr1158205wry; Fri, 17 Jun 2005 08:08:59 -0700 (PDT) Received: by 10.54.129.3 with HTTP; Fri, 17 Jun 2005 08:08:59 -0700 (PDT) Message-ID: Date: Fri, 17 Jun 2005 16:08:59 +0100 From: Kailash Vyas Reply-To: Kailash Vyas To: pgsql-admin@postgresql.org Subject: Re: wal logging Cc: Tom Lane In-Reply-To: <20172.1119016836@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3808_21631432.1119020939630" References: <20172.1119016836@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.121 tagged_above=0 required=5 tests=AWL, HTML_50_60, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/130 X-Sequence-Number: 17885 ------=_Part_3808_21631432.1119020939630 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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= =20 recovering it through WAL. thanks, kailash On 6/17/05, Tom Lane wrote: >=20 > Kailash Vyas writes: > > what is the utility of WAL logging in postgres 7.3 >=20 > Crash protection. >=20 > regards, tom lane > ------=_Part_3808_21631432.1119020939630 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 r= ecovering it through WAL.

thanks,
kailash

On 6/17/05, Tom Lane <tgl@sss.pgh.pa.us= > wrote:
Kailash Vyas <kailash.vyas@gma= il.com> writes:
> what is the utility of WAL logging in postgr= es 7.3

Crash protection.

      =             &nb= sp;     regards, tom lane

------=_Part_3808_21631432.1119020939630--