On Thu, 2007-09-27 at 14:26 -0700, Cyrus Durgin wrote: > hi, > > i'm using sqlite3 in a small project that will run on multiple servers. > only one of the instances will be read-write to the database, the others are > all read-only. i understand that the recommended process for replication on > the read-write instance looks something like: > > BEGIN EXCLUSIVE; > <copy database file> > COMMIT; > > is it roughly the same on the read-only (destination) side? in other words > is: > > BEGIN EXCLUSIVE; > <copy new file into place> > COMMIT; > > the correct procedure?
I think you will need to make sure that all SQLite instances have closed the read-only database before copying over it. Otherwise all the existing connections will continue to read the old data. Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
