How to manage WAL
| От | Albert Shih |
|---|---|
| Тема | How to manage WAL |
| Дата | |
| Msg-id | 20100211223245.GA13434@obspm.fr обсуждение исходный текст |
| Ответы |
Re: How to manage WAL
|
| Список | 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
В списке pgsql-admin по дате отправления: