Re: replication - Mailing list pgsql-admin

From Chris Browne
Subject Re: replication
Date
Msg-id 60zmqvytkv.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to replication  (Alain Rodriguez Arias <alainrod@gmail.com>)
List pgsql-admin
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/>

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: replication
Next
From: Marek Dabrowski
Date:
Subject: VACUMM problem