Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 96E3E9FC798 for ; Wed, 31 Oct 2007 15:27:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 81204-01-6 for ; Wed, 31 Oct 2007 15:27:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mmp3.nems.noaa.gov (mmp3.nems.noaa.gov [140.90.121.158]) by postgresql.org (Postfix) with ESMTP id 294379FC7E6 for ; Wed, 31 Oct 2007 14:14:41 -0300 (ADT) Received: from [198.187.158.214] ([208.252.125.103]) by mmp3.nems.noaa.gov (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTPSA id <0JQS00AWGD8ADF00@mmp3.nems.noaa.gov> for pgsql-sql@postgresql.org; Wed, 31 Oct 2007 13:14:40 -0400 (EDT) Date: Wed, 31 Oct 2007 10:14:33 -0700 From: Joanne Salerno Subject: Backup Database To: pgsql Message-id: <4728B7F9.5030308@noaa.gov> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT User-Agent: Thunderbird 1.5.0.9 (X11/20061219) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/155 X-Sequence-Number: 29527 I have two Postgres databases (7.4 and 8.24) within the same network on LINUX platforms. Data sources go to both databases. I'd like to set up one as a near real-time backup to the operational database. Is it possible to incorporate a trigger upon update (or insert) on the operational 8.24 database to initiate an update (or insert) on the backup 7.4 database? How do most people set up a near real-time backup database? Perhaps there is something else that acts like a trigger. Any suggestions would be helpful. Thanks. Joanne