Re: replication

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication
Date: 2005-09-02 22:48:32
Message-ID: 60zmqvytkv.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

alainrod(at)gmail(dot)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/>

In response to

  • replication at 2005-09-02 20:11:35 from Alain Rodriguez Arias

Browse pgsql-admin by date

  From Date Subject
Next Message Marek Dabrowski 2005-09-03 13:21:47 VACUMM problem
Previous Message Alvaro Herrera 2005-09-02 21:04:32 Re: replication