From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Alexander Burbello <burbello3000@yahoo.com.br>
Cc: Aaron Bono <postgresql@aranya.com>
Cc: Lista Postgres <pgadmin-support@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Restore Database
Date: Thu, 13 Jul 2006 17:45:46 -0500
Message-ID: <1152830746.14241.101.camel@state.g2switchworks.com> (raw)
In-Reply-To: <44B555D3.4080605@yahoo.com.br>
References: <20060711171232.83182.qmail@web36205.mail.mud.yahoo.com>
<bf05e51c0607121241r6124d7eau62de3bbe765721bb@mail.gmail.com>
<44B555D3.4080605@yahoo.com.br>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, burbello3000@yahoo.com.br, postgresql@aranya.com, pgadmin-support@postgresql.org
Subject: Re: [ADMIN] Restore Database
In-Reply-To: <1152830746.14241.101.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox