Re: Big 7.4 items - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: Big 7.4 items
Date
Msg-id 200212161932.58595.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Re: Big 7.4 items  (Greg Copeland <greg@CopelandConsulting.Net>)
Responses Re: Big 7.4 items
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: Big 7.4 items
Next
From: Greg Copeland
Date:
Subject: Re: Big 7.4 items