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