| 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: | Whole Thread | Raw Message | 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
| 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 |