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

-- 
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to