How to manage WAL

From: Albert Shih <Albert(dot)Shih(at)obspm(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to manage WAL
Date: 2010-02-11 22:32:45
Message-ID: 20100211223245.GA13434@obspm.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albert Shih 2010-02-11 22:43:41 Re: pg_xlog
Previous Message Joshua D. Drake 2010-02-11 22:24:37 Re: pg_xlog