On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote:
I know ppl are using it to do replication, but has anyone
documented what is involved in doing so?
thanks ...
I'll be curious to hear stories of people using it for replication.
The way I interpret replication, there's an available database (even
if read-only) on both ends. With PITR/on-line backups, the way I
understand it, there's no way to provide availability to the recovery
database because it's in a process of continuous recovery. It
qualifies as high availability in terms of a failover solution, but
the recovery database is not actually available until something
triggers it to recover, at which point any writing done to it causes
it to cease to be a replicant of the base database.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)