pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication with PostgreSQL
3+ messages / 3 participants
[nested] [flat]
* Replication with PostgreSQL
@ 2005-03-17 14:33 prakash sompura <prakash@ritvi.com>
2005-03-21 03:33 ` Re: Replication with PostgreSQL Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 3+ messages in thread
From: prakash sompura @ 2005-03-17 14:33 UTC (permalink / raw)
To: pgsql-admin
Hi
Can any one tell me how do I replicate my PostgreSql database from one
server to another server?
Prakash
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Replication with PostgreSQL
2005-03-17 14:33 Replication with PostgreSQL prakash sompura <prakash@ritvi.com>
@ 2005-03-21 03:33 ` Christopher Browne <cbbrowne@acm.org>
2005-03-22 21:21 ` Re: Replication with PostgreSQL Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher Browne @ 2005-03-21 03:33 UTC (permalink / raw)
To: pgsql-admin
After a long battle with technology, prakash@ritvi.com (prakash sompura), an earthling, wrote:
> Can any one tell me how do I replicate my PostgreSql database from
> one server to another server?
One method involves using pg_dump to dump the state out, and load it
onto the other server. Certainly this is the simplest way to do a one
point in time replication.
Another involves using the PG 8.0 "PITR" (Point In Time Recovery)
facility.
If you want the replica to be relatively up to date and usable more or
less continuously as a queryable replica, then you should look into
one or another of the replication systems. Slony-I is the "hot name"
at this point...
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com').
http://linuxdatabases.info/info/slony.html
"If a word in the dictionary were misspelled, how would we know?"
-- Steven Wright
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Replication with PostgreSQL
2005-03-17 14:33 Replication with PostgreSQL prakash sompura <prakash@ritvi.com>
2005-03-21 03:33 ` Re: Replication with PostgreSQL Christopher Browne <cbbrowne@acm.org>
@ 2005-03-22 21:21 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: Joshua D. Drake @ 2005-03-22 21:21 UTC (permalink / raw)
To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-admin
On Sun, 2005-03-20 at 22:33 -0500, Christopher Browne wrote:
> After a long battle with technology, prakash@ritvi.com (prakash sompura), an earthling, wrote:
> > Can any one tell me how do I replicate my PostgreSql database from
> > one server to another server?
You can use Mammoth Replicator or Slony.
Replicator can be found here:
http://www.commandprompt.com/
Slony can be found here:
http://www.slony.info
Replicator is easier to setup and manage but it is not free.
Sincerely,
Joshua D. Drake
>
> One method involves using pg_dump to dump the state out, and load it
> onto the other server. Certainly this is the simplest way to do a one
> point in time replication.
>
> Another involves using the PG 8.0 "PITR" (Point In Time Recovery)
> facility.
>
> If you want the replica to be relatively up to date and usable more or
> less continuously as a queryable replica, then you should look into
> one or another of the replication systems. Slony-I is the "hot name"
> at this point...
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-03-22 21:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-17 14:33 Replication with PostgreSQL prakash sompura <prakash@ritvi.com>
2005-03-21 03:33 ` Christopher Browne <cbbrowne@acm.org>
2005-03-22 21:21 ` Joshua D. Drake <jd@commandprompt.com>
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