Search Postgresql Archives

Re: Syncing Databases Weekly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 main server once a week, at the end of the updates I would like to automatically copy all of the data to a second server as a live backup in case the main system ever goes down.



You could use batch replication via Mammoth Replicator or PITR.

Slony's log shipping is another option.

Oh cool... I didn't know Slony could do that. Glad to hear it.






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux