Re: Replication with PostgreSQL

After a long battle with technology, prakash(at)ritvi(dot)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