X-Original-To: pgadmin-support-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CC19D9FB2AC; Thu, 13 Jul 2006 19:45:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 77101-06; Thu, 13 Jul 2006 19:45:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 6E2539FA7BA; Thu, 13 Jul 2006 19:45:48 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 13 Jul 2006 22:45:46 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 13 Jul 2006 17:45:46 -0500 Subject: Re: [ADMIN] Restore Database From: Scott Marlowe To: Alexander Burbello Cc: Aaron Bono , Lista Postgres , pgsql-admin@postgresql.org In-Reply-To: <44B555D3.4080605@yahoo.com.br> References: <20060711171232.83182.qmail@web36205.mail.mud.yahoo.com> <44B555D3.4080605@yahoo.com.br> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1152830746.14241.101.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 13 Jul 2006 17:45:46 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/35 X-Sequence-Number: 5608 On Wed, 2006-07-12 at 15:04, Alexander Burbello wrote: > Ok! Its a good tool, but for Production Database I think it is not > recommended. > Only using pg_dump for the second backup plain. > Suppose that you backed up at 6:00am and at 9am happened a crash on the > server. > In this case, I would lost data between that time, 3 hours of information. > > For production databases, my plan is to do phisical backup including WAL. > If a crash happen, I can restore the datafiles and recover applying the > WAL logs until the last file was generated. > As Oracle does in this type of crash. > > My doubt is that I am not getting apply the WAL files on recover stage. > > Any other suggestion? You have read this section of the manual, right? http://www.postgresql.org/docs/8.1/interactive/backup-online.html