Обсуждение: replication
Please,anybody can tell me how to make replication of a PostGre DB????
On Fri, Sep 02, 2005 at 04:11:35PM -0400, Alain Rodriguez Arias wrote: > Please,anybody can tell me how to make replication of a PostGre DB???? Did you already look at Slony-I, www.slony.info ? -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com "I think my standards have lowered enough that now I think 'good design' is when the page doesn't irritate the living f*ck out of me." (JWZ)
alainrod@gmail.com (Alain Rodriguez Arias) writes: > Please,anybody can tell me how to make replication of a PostGre DB???? What do you mean by "replication?" - If what you desire is to create a copy, then you can take a backup and restore it somewhere else. Read The Fine Manual if that fits your need. <http://www.postgresql.org/docs/current/static/backup.html> - If what you require instead is that the replica mirror the activity that takes place on the database in which you perform updates, then you should probably look into Slony-I. URL to documentation for that below. -- output = reverse("moc.enworbbc" "@" "enworbbc") http://cbbrowne.com/info/slony.html Rules of the Evil Overlord #67. "No matter how many shorts we have in the system, my guards will be instructed to treat every surveillance camera malfunction as a full-scale emergency." <http://www.eviloverlord.com/>