X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A76E156567 for ; Mon, 21 Mar 2005 04:12:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32969-04 for ; Mon, 21 Mar 2005 04:12:06 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 6F89C531C8 for ; Mon, 21 Mar 2005 04:12:01 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j2L4C0v1033426 for ; Mon, 21 Mar 2005 04:12:00 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j2L3o2bb026312 for pgsql-admin@postgresql.org; Mon, 21 Mar 2005 03:50:02 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Replication with PostgreSQL Date: Sun, 20 Mar 2005 22:33:10 -0500 Organization: cbbrowne Computing Inc Lines: 20 Message-ID: References: <4239952F.9070601@ritvi.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:cP9mLlHbGR/Drk7nSh+mfXZJpA0= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/322 X-Sequence-Number: 16820 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