Re: [GENERAL] Syncing Databases Weekly

2006-02-08 Thread Vivek Khera
On Feb 7, 2006, at 1:34 PM, Brad Nicholson wrote: Slony's log shipping is another option. But that requires at least one regular replica to exist as well. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Syncing Databases Weekly

2006-02-07 Thread Joshua D. Drake
Brad Nicholson wrote: Joshua D. Drake wrote: Benjamin Arai wrote: Hi, I am familiar with applications like slony for replications, I am looking for a technique for syncing a very large database every week for backup and redundancy purposes. More specifically, I do all my writes to a ma

Re: [GENERAL] Syncing Databases Weekly

2006-02-07 Thread Brad Nicholson
Joshua D. Drake wrote: Benjamin Arai wrote: Hi, I am familiar with applications like slony for replications, I am looking for a technique for syncing a very large database every week for backup and redundancy purposes. More specifically, I do all my writes to a main server once a week, a

Re: [GENERAL] Syncing Databases Weekly

2006-02-07 Thread Joshua D. Drake
Benjamin Arai wrote: Hi, I am familiar with applications like slony for replications, I am looking for a technique for syncing a very large database every week for backup and redundancy purposes. More specifically, I do all my writes to a main server once a week, at the end of the updates

Re: [GENERAL] Syncing Databases Weekly

2006-02-07 Thread Richard Huxton
Benjamin Arai wrote: Hi, I am familiar with applications like slony for replications, I am looking for a technique for syncing a very large database every week for backup and redundancy purposes. More specifically, I do all my writes to a main server once a week, at the end of the updates I w

[GENERAL] Syncing Databases Weekly

2006-02-07 Thread Benjamin Arai
Hi,   I am familiar with applications like slony for replications, I am looking for a technique for syncing a very large database every week for backup and redundancy purposes.  More specifically, I do all my writes to a main server once a week, at the end of the updates I would like to auto