Received: from smtp.noos.fr (lafontaine.noos.net [212.198.2.72]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1EA9lE27528 for ; Thu, 14 Feb 2002 05:09:47 -0500 (EST) (envelope-from lpatureau@idfr.net) Received: (qmail 10107010 invoked by uid 0); 14 Feb 2002 10:09:47 -0000 Received: from unknown (HELO idfrportable.idfr.net) ([195.132.30.156]) (envelope-sender ) by 212.198.2.72 (qmail-ldap-1.03) with SMTP for ; 14 Feb 2002 10:09:47 -0000 Message-Id: <5.1.0.14.0.20020214110508.02e24f40@pop.noos.fr> X-Sender: lpatureau@pop.noos.fr X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 14 Feb 2002 11:09:26 +0100 To: pgsql-sql@postgresql.org From: Laurent Patureau Subject: synchronise 2 db pgsql ? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200202/150 X-Sequence-Number: 6577 Hi, I've 2 databases on 2 differents server. I want to synchronise one that is source to the other (mirroring). The database's name are the same. How can I do it properly ? I wouldn't want to do : dump db1, drop db2, read_dump db2. Thanks for your help Regards, Laurent.