X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0B076D1C50B for ; Tue, 13 Apr 2004 08:39:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53767-10 for ; Tue, 13 Apr 2004 08:39:21 -0300 (ADT) Received: from kieser1.demon.co.uk (unknown [195.166.116.245]) by svr1.postgresql.org (Postfix) with ESMTP id BF116D1BBA1 for ; Tue, 13 Apr 2004 08:39:17 -0300 (ADT) Received: from kieser.net (localhost.localdomain [127.0.0.1]) by kieser1.demon.co.uk (Postfix) with ESMTP id C704E69472 for ; Tue, 13 Apr 2004 06:45:55 -0400 (EDT) Message-ID: <407B85CF.4010404@kieser.net> Date: Tue, 13 Apr 2004 06:16:47 +0000 From: Bradley Kieser User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en, en-us MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Real time replication of PG DBs accross two servers - any experiences? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/196 X-Sequence-Number: 13169 Hi All, I desperately need to set up a real time replication of several databases (for failover) between two servers. Last time I looked at the PG replication it wasn't yet production level. I wonder if anyone on this list is doing this successfully and if you won't mind sharing your experience and giving me any tips that you may think would be handy from a real world perspective I would very much appreciate it. I am 100% Linux-based, in case that makes a difference! I have also considered using the CODA files system in case the replication isn't quite up to production levels still. Thanks, Brad