On Monday 16 December 2002 07:26 pm, you wrote: > I'm curious, what would be the recovery strategy for PITR master-slave > replication should the master fail (assuming hot fail over/backup)? A > simple dump/restore? Are there/is there any facilities in PorstgreSQL > for PITR archival which prevents PITR logs from be recycled (or perhaps, > simply archived off)? What about PITR streaming to networked and/or > removable media?
In asynchrounous replication, WAL log records are fed to anoter host, which replays those transactions to sync the data. This way it does not matter if WAL log is recycled as it is already replicated someplace else.. HTH Shridhar ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
