Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 17ED964FCCF for ; Fri, 22 Aug 2008 15:08:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30048-02 for ; Fri, 22 Aug 2008 15:08:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.226]) by postgresql.org (Postfix) with ESMTP id 8A88765015A for ; Fri, 22 Aug 2008 15:08:15 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id d8so861060qbc.23 for ; Fri, 22 Aug 2008 11:08:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=uD8fayqmf1440b6ZcNvazeDmvF/3XfSDRjEjpFjCHvA=; b=QSq53TVKtE0LDju5KBJm1LpG9jJAjhHgroxG6+bDiOwSCZ61yz+DHozI31jYknAM4O a+gjoBC4ymWNP4L47wzKz4JB3S3nh5Lrymr4/8J2DGrijOHXI49obiMEV+em1abSuAPi hQb3FJKr/1HTFYjkap8Nj3OREtIkiYgi8NEiQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=RkEq+sdZi+TCHqycENDNKsUGrUxPFXZjVruk7tGnHmso2JQWnCPrDtZP+DZ+dxcmQO tEk/VT8rwdE8R/yD/bgb4Z4gSQ1f/WzUbmwS7yv1fjDSl8DfP6sZLWm3eE6LbnurosHp MLXsiLN/WtzrG8+jhCWXD0FIFg/VY9WTagwEs= Received: by 10.64.195.20 with SMTP id s20mr1545198qbf.20.1219428493341; Fri, 22 Aug 2008 11:08:13 -0700 (PDT) Received: by 10.65.200.5 with HTTP; Fri, 22 Aug 2008 11:08:13 -0700 (PDT) Message-ID: Date: Fri, 22 Aug 2008 23:38:13 +0530 From: "c k" To: "Tomeh, Husam" , pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Auto recovery feature In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34772_3109691.1219428493327" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/127 X-Sequence-Number: 29972 ------=_Part_34772_3109691.1219428493327 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks CPK On Fri, Aug 22, 2008 at 11:36 PM, Tomeh, Husam wrote: > Postgres, like any descent RDBMS, performs an auto instance crash > recovery using its transaction logs. > > > > Regards, > > Husam > ------------------------------ > > *From:* pgsql-admin-owner@postgresql.org [mailto: > pgsql-admin-owner@postgresql.org] *On Behalf Of *c k > *Sent:* Friday, August 22, 2008 11:02 AM > *To:* pgsql-general@postgresql.org; pgsql-admin@postgresql.org > *Subject:* [ADMIN] Auto recovery feature > > > > Hello all, > As I know and have seen that innodb engine of MySQL does an auto-recovery > when MySQL server is crashed or due to power failure. What is with > postgreSQL? Does it makes an auto-recovery? and how? > > Thanks > CPK > > ********************************************************************** > This message contains confidential information intended only for the use of > the addressee(s) named above and may contain information that is legally > privileged. If you are not the addressee, or the person responsible for > delivering it to the addressee, you are hereby notified that reading, > disseminating, distributing or copying this message is strictly prohibited. > If you have received this message by mistake, please immediately notify us > by replying to the message and delete the original message immediately > thereafter. > > Thank you. > > > FADLD Tag > ********************************************************************** > ------=_Part_34772_3109691.1219428493327 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Thanks
CPK

On Fri, Aug 22, 2008 at 11:36 PM, Tomeh, Husam <HTomeh@facorelogic.com> wrote:

Postgres, like any descent RDBMS, performs an auto instance crash recovery using its transaction logs.

 

Regards,

      Husam

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of c k
Sent: Friday, August 22, 2008 11:02 AM
To: pgsql-general@postgresql.org; pgsql-admin@postgresql.org
Subject: [ADMIN] Auto recovery feature

 

Hello all,
As I know and have seen that innodb engine of MySQL does an auto-recovery when MySQL server is crashed or due to power failure. What is with postgreSQL? Does it makes an auto-recovery? and how?

Thanks
CPK

**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                                                                                                         FADLD Tag
**********************************************************************


------=_Part_34772_3109691.1219428493327--