From: Albert Shih <Albert.Shih@obspm.fr>
To: pgsql-admin@postgresql.org
Subject: How to manage WAL
Date: Thu, 11 Feb 2010 23:32:45 +0100
Message-ID: <20100211223245.GA13434@obspm.fr> (raw)
Hi all
I would like to known what's best way to manage the WAL.
Let's me explain :
at beginning I do something like
psql -c "select pg_start_backup('complete');"
rsync /pgsql backup_server:
psql -c "select pg_stop_backup();"
and I backup /WAL directory but after sometime the /WAL directory
become big. So can I do something like
postgresql stop
rm /WAL/*
postgresql start
psql -c "select pg_start_backup('complete');"
rsync /pgsql backup_server:
psql -c "select pg_stop_backup();"
and continu to backup /WAL ?
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Jeu 11 fév 2010 23:28:31 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
Subject: Re: How to manage WAL
In-Reply-To: <20100211223245.GA13434@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