From: Albert Shih <Albert.Shih@obspm.fr>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to manage WAL
Date: Fri, 12 Feb 2010 12:42:04 +0100
Message-ID: <20100212114204.GA92765@obspm.fr> (raw)
In-Reply-To: <20100211233930.GL3145@alvh.no-ip.org>
References: <20100211223245.GA13434@obspm.fr>
<4B7437B1020000250002F1FD@gw.wicourts.gov>
<20100211233225.GA55871@obspm.fr>
<20100211233930.GL3145@alvh.no-ip.org>
Le 11/02/2010 à 20:39:30-0300, Alvaro Herrera a écrit
> Albert Shih wrote:
> > Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit
> > > Albert Shih <Albert.Shih@obspm.fr> wrote:
> > >
> > > > I would like to known what's best way to manage the WAL.
> > >
> > > You should design a policy which meets your particular needs. We
> > > keep two PITR base backups and all the WAL files from before the
> > > start of the first (based on the information in the backup file)
> > > through current. We also save monthly archival PITR base backups
> > > with just the WAL files needed to restore them (again, based on the
> > > backup files). Your needs may be different.
> >
> > Hum...I'm not sure I really understand what you doing.
> >
> > Maybe I'm doing everything wrong but this is what I did :
> >
> > t=0 SELECT pg_start_backup('label');
> > rsync /pgsql backup_server:/
> > SELECT pg_stop_backup();
> >
> > t> 1 cron with rsync /WAL backup_server:
> >
> > but after some time the /WAL become big. So is it a solution to
> > stop the database, delete everything in /WAL and begin a new cycle (t=0 select etc...) ?
>
> You could do that if you wanted, but there's a window during which you
> have no backup at all. Perhaps it's better to take a second base
> backup, start archiving to a different directory /WAL2, and when the
> second base backup is done you can delete /WAL
Thanks for you help and advise. But for me that's not be a problem because
I can stop the database when I want. And my database is huge (~800go) and
important but not critical. The critical database is very small (~ 1Go) and
for this I use pgdump.
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Ven 12 fév 2010 12:38:53 CET
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: Albert.Shih@obspm.fr, alvherre@commandprompt.com, Kevin.Grittner@wicourts.gov
Subject: Re: How to manage WAL
In-Reply-To: <20100212114204.GA92765@obspm.fr>
* 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