Albert Shih <Albert.Shih@xxxxxxxx> wrote: > I would like to known what's best way to manage the WAL. You should design a policy which meets your particular needs. We keep two PITR base backups and all the WAL files from before the start of the first (based on the information in the backup file) through current. We also save monthly archival PITR base backups with just the WAL files needed to restore them (again, based on the backup files). Your needs may be different. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
