From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: replication
Date: Fri, 02 Sep 2005 18:48:32 -0400
Message-ID: <60zmqvytkv.fsf@dba2.int.libertyrms.com> (raw)
References: <526cb99d050902131172fa6338@mail.gmail.com>
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/;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: replication
In-Reply-To: <60zmqvytkv.fsf@dba2.int.libertyrms.com>
References: <526cb99d050902131172fa6338@mail.gmail.com> <60zmqvytkv.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox