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 46AFE9FB35D for ; Fri, 14 Jul 2006 12:22:18 -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 32633-03 for ; Fri, 14 Jul 2006 12:22:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.cresoltec.com.br (unknown [200.103.143.8]) by postgresql.org (Postfix) with SMTP id C0C489FB334 for ; Fri, 14 Jul 2006 12:22:08 -0300 (ADT) Received: (qmail 3828 invoked from network); 14 Jul 2006 11:44:10 -0000 Received: from unknown (HELO ?10.90.2.162?) (10.90.2.162) by mail.cresoltec.com.br with SMTP; 14 Jul 2006 11:44:10 -0000 Message-ID: <44B7833E.8080202@yahoo.com.br> Date: Fri, 14 Jul 2006 08:42:54 -0300 From: Alexander Burbello User-Agent: Mozilla Thunderbird 1.0.2 (X11/20060423) X-Accept-Language: pt-br, pt MIME-Version: 1.0 To: Lista Postgres , pgsql-admin@postgresql.org Subject: Re: [ADMIN] Restore Database References: <20060711171232.83182.qmail@web36205.mail.mud.yahoo.com> <44B555D3.4080605@yahoo.com.br> <1152830746.14241.101.camel@state.g2switchworks.com> In-Reply-To: <1152830746.14241.101.camel@state.g2switchworks.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/39 X-Sequence-Number: 5612 Yes! I followed exactly that page to do. Thanks Scott Marlowe escreveu: >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 > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > >