Postgres Pro
Downloads
Home   >   mailing lists

Thread: replication

replication

From
Alain Rodriguez Arias
Date:
Please,anybody can tell me how to make replication of a PostGre DB????

Re: replication

From
Alvaro Herrera
Date:
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)

Re: replication

From
Chris Browne
Date:
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/>