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 AC64552935 for ; Fri, 17 Jun 2005 10:09:59 -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 14050-10 for ; Fri, 17 Jun 2005 13:09:56 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id 7EAB35294C for ; Fri, 17 Jun 2005 10:09:50 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 37so1087936wra for ; Fri, 17 Jun 2005 06:09:53 -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=LtZu/grYdQvPSJFmJqOPx6NHR3nc9yprOVRAzkdXr3+J7tmlaKaVdI6V0I3U79oVhJAeXOTROx2ROwTOM7cveFO5CNw/9H4o1AotqPQFmWRemH+tSg2qlYz3PybP9ak0dklek4QKZ56bvfnUSVtgZv7SPqFH2gWKvNZJvb7x5sg= Received: by 10.54.25.75 with SMTP id 75mr1093390wry; Fri, 17 Jun 2005 06:09:53 -0700 (PDT) Received: by 10.54.129.3 with HTTP; Fri, 17 Jun 2005 06:09:53 -0700 (PDT) Message-ID: Date: Fri, 17 Jun 2005 14:09:53 +0100 From: Kailash Vyas Reply-To: Kailash Vyas To: pgsql-admin@postgresql.org Subject: Re: wal logging Cc: "thomas.revell@powerconv.alstom.com" In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3348_22921286.1119013793445" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.122 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/127 X-Sequence-Number: 17882 ------=_Part_3348_22921286.1119013793445 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline thanks for the info. what is the utility of WAL logging in postgres 7.3=20 thanks, kailash On 6/17/05, thomas.revell@powerconv.alstom.com < thomas.revell@powerconv.alstom.com> wrote: >=20 > Database recovery from write ahead logs is only supported in PostgreSQL > 8.0.0 and later. >=20 > ----------------------------------------------------------------------- > hi >=20 > 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? >=20 > 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 i= t >=20 > thanks, > kailash >=20 >=20 > :.________________ > 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, us= e > it for any purpose or store or copy the information in any medium. >=20 > ---------------------------(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 > ------=_Part_3348_22921286.1119013793445 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline thanks for the info.
what is the utility of WAL logging in postgres 7.3

thanks,
kailash

On 6/17/05, thomas= .revell@powerconv.alstom.com < thomas.revell@powerconv.alstom.com> wrote:
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 dat= abase.
what are the steps to be followed in postgres regarding logical
corr= uption, instance failures, block corruption, log corruption?

I am us= ing postgres 7.3.9
I was checking out WAL logging. I enabled WAL logging= in=20 postgres.conf
I found the logs in the pg_xlog directory but don't know h= ow to recover it

thanks,
kailash


:.________________CONFIDENTIALITY : This  e-mail  and  any att= achments 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 anothe= r 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 appropria= te
      subscribe-nomail command to majordomo@postgresql.org so that your
     =  message can get through to the mailing list cleanly
<= /div>
------=_Part_3348_22921286.1119013793445--