sparky@unm.edu (john richard lawton) writes:
: 
:    We have 2 large, identically structured databases ( >100 tables, 
: gigabytes of data) on two different Ingres servers. Both have the same 
: name.  One of the databases is slightly more up-to-date than the other.  
: We'd like to have both of them to be identical.
: 
: The obvious solution would be to unload the current one and the copy it into
: the other installation. From past experience, we know this would take about 20
: hours or so.
: 
: What we're thinking of doing is checkpointing our current database, copying
: that checkpoint file to the installation of the other database, renaming it so
: Ingres will think it's the latest checkpoint for that database, then doing
: a rollforward.
: 
: Has anybody does this?  Does it work?  Any other methods for a quicker
: database copy?

The Ingres Replicator is designed for this.  If this is a serious
production application use the Replicator.  Otherwise, maybe you'd be
quickest to use the operating system backup utility to dump one system
and restore it to the other.  

--Roy Hann

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William