In message <[EMAIL PROTECTED]> you wrote: > >Hi everybody, > >is there a way to have two systems working offline , ie making backup in one > >system and then resotre it in the other , > >I need to have two sites to work with SL but it is not feasable to have a > >leased line or an open internet connection all the time in both sites , > >How can this be done ? > > ..with a LOT of homework. The sites are in seperate physical locations?
I use pg_dump to write the database to a file, gzip to compress it, "mount ; cp ; umount" to get it to the remote site, then dropdb ; createdb ; gzip -d | psql -U ... -d ... to restore it. Note that the second copy is a write-irrelevant copy outside the firewall. > > You are looking at "almost real time backup", using rsync and nfs > through stunnel, and packet filtering firewalls that do NAT and > Masqerading for starters. Not good. AFAICT, postgres likes to have the same inodes as before in the database? Any attempt to use rsync will be ...bad. cheers, Rich. -- Rich Walker: [EMAIL PROTECTED] (Shadow Robot Project) http://www.shadow.org.uk 251 Liverpool Road +44(0)171 700 2487 London N1 1LX "Sometimes after an electrical storm I see in 5 dimensions" -- Cornfed Pig, Duckman. ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
