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 29BFBD1D391 for ; Tue, 17 Feb 2004 12:08:24 +0000 (GMT) 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 22129-06 for ; Tue, 17 Feb 2004 08:08:24 -0400 (AST) Received: from pengo.systems.pipex.net (pengo.systems.pipex.net [62.241.160.193]) by svr1.postgresql.org (Postfix) with ESMTP id D4DAFD1B511 for ; Tue, 17 Feb 2004 08:08:02 -0400 (AST) Received: from linux (81-86-118-3.dsl.pipex.com [81.86.118.3]) by pengo.systems.pipex.net (Postfix) with ESMTP id B6FE84C0047A for ; Tue, 17 Feb 2004 12:07:59 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" From: Andrew Poodle To: pgsql-admin@postgresql.org Subject: remote synchronisation Date: Tue, 17 Feb 2004 12:08:01 +0000 User-Agent: KMail/1.4.3 Organization: simplis-IT MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200402171208.01540.andrew@simplis-it.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/260 X-Sequence-Number: 12434 Hi, new to the list, and relatively new to Postgres admin too but here's my=20 situation. I have a website running on PHP/Postgres and I'd like to set up a secondary= =20 box which can be used to fall back on should the primary die for some reaso= n.=20=20 How would I go about ensuring the databases are kept current and synchronis= ed=20 while the systems are both live, and how would I do a compare once the dead= =20 box has come back up to allow me to load the missing data? can this be don= e=20 with any psql tools, or is it a case of getting jiggy with a ton of shell= =20 scripting and PL/SQL? incidentally.. the two boxes are remote to each other and both run apache a= nd=20 postgres, serving the data to themselves. thanks a