Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.10.1) with ESMTP id e8LCpKs74801 for ; Thu, 21 Sep 2000 08:51:20 -0400 (EDT) Received: from Adam ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id IAA01501 for ; Thu, 21 Sep 2000 08:56:57 -0400 Message-ID: <001d01c023ca$e37d9cc0$330a0a0a@Adam> From: "Adam Lang" To: "PGSQL General" Subject: replication Date: Thu, 21 Sep 2000 08:52:53 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200009/606 Are there any type of replication features in postgresql 7.0? I would like it where two databases have the same structure, but say at midnight every night Database 1 synchs up database 2. Granted, I could always write code to do that, but it wouldn't be very sophisticated. (If I coded it, would do something like find rows in table 1 which aren't in the second database, append them database two, same with the second table, etc.) Adam Lang Systems Engineer Rutgers Casualty Insurance Company