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 86E633A3EA7 for ; Tue, 23 Nov 2004 12:47:08 +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 32790-03 for ; Tue, 23 Nov 2004 12:46:51 +0000 (GMT) Received: from mta02.onolab.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id 8849A3A3E55 for ; Tue, 23 Nov 2004 12:46:15 +0000 (GMT) Received: from [155.54.15.114] by mta02.onolab.com with HTTP; Tue, 23 Nov 2004 13:46:00 +0100 Date: Tue, 23 Nov 2004 13:46:00 +0100 Message-ID: <415C438C0002279F@mta02.ono.com> From: mariabreis@ono.com Subject: Synchronize 2 postgres db To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200411/169 X-Sequence-Number: 15553 Hi! My problem is tha I hava a remote db and a local db (with the same schema= ). When I can connect to the remote db I want to synchronize data between th= em. Is there any tool for this? or do I have to write the sql commands? Thanks! Maria