Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 445C99F9869
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  5 Nov 2007 05:31:02 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 93066-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  5 Nov 2007 05:30:57 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172])
	by postgresql.org (Postfix) with ESMTP id 357A09F9868
	for <pgsql-sql@postgresql.org>; Mon,  5 Nov 2007 05:30:56 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id j3so883998ugf
	for <pgsql-sql@postgresql.org>; Mon, 05 Nov 2007 01:30:55 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=p2uL2KfgaDDFCq/aCmdgSW92J5odBATsBJgoMbNXN5k=;
	b=TyUmno6mkBenLXvkch0F2gdn2pWNf8IaF0YeC7ZnwjPCChPp0xcloxTORAp1KU8h2+SAP0E9P41/DJrFBY1+1oiqmfU8cDxgh4ya2L/0K3LmBBNl4wYxRzGJaxhhswFlifkOT5mIXWYo3+Uqpnat1d0EIO+J87PjcGjPWRbEgTs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:references;
	b=NAwtZBi12QM0pFMzNJqYjA1xzO0xBkApr/dvcawQKVtLokGfPh5gVkAeepJJdZmG41BaUcBd/6X/WkH8l0ixyrdtAOWaTE2fhGXeLI5DdT5z4VCXqtUvhbXxrAJGhDIkHbsz8a8WDOYpSK3XxwRohY9w5ED7mCF7FWl3YFzHPG8=
Received: by 10.66.244.20 with SMTP id r20mr2239964ugh.1194255055278;
	Mon, 05 Nov 2007 01:30:55 -0800 (PST)
Received: by 10.66.248.10 with HTTP; Mon, 5 Nov 2007 01:30:55 -0800 (PST)
Message-ID: <ecd779860711050130j60ea6246gd9c4b8e4b3be7ae0@mail.gmail.com>
Date: Mon, 5 Nov 2007 11:30:55 +0200
From: "Asko Oja" <ascoja@gmail.com>
Subject: Re: Backup Database
Cc: pgsql <pgsql-sql@postgresql.org>
In-Reply-To: <4728B7F9.5030308@noaa.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6392_12857224.1194255055276"
References: <4728B7F9.5030308@noaa.gov>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/10
X-Sequence-Number: 29538

------=_Part_6392_12857224.1194255055276
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

We do it with Skytools. In addition to replication with Londiste it hs lot's
of other useful scripts for keeping online database small and healthy.

Asko


On 10/31/07, Joanne Salerno <joanne.salerno@noaa.gov> wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

------=_Part_6392_12857224.1194255055276
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi<br><br>We do it with Skytools. In addition to replication with Londiste it hs lot&#39;s of other useful scripts for keeping online database small and healthy.<br><br>Asko<br><br><br><div><span class="gmail_quote">On 10/31/07, 
<b class="gmail_sendername">Joanne Salerno</b> &lt;<a href="mailto:joanne.salerno@noaa.gov">joanne.salerno@noaa.gov</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have two Postgres databases (7.4 and 8.24) within the same network on<br>LINUX platforms. Data sources go to both databases.<br><br>I&#39;d like to set up one as a near real-time backup to the operational<br>database.&nbsp;&nbsp;Is it possible to incorporate a trigger upon update (or
<br>insert) on the operational 8.24 database to initiate an update (or<br>insert) on the backup 7.4 database?<br><br>How do most people set up a near real-time backup database?&nbsp;&nbsp;Perhaps<br>there is something else that acts like a trigger.&nbsp;&nbsp;Any suggestions would
<br>be helpful.<br><br>Thanks.&nbsp;&nbsp;Joanne<br><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 4: Have you searched our list archives?<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://archives.postgresql.org">
http://archives.postgresql.org</a><br></blockquote></div><br>

------=_Part_6392_12857224.1194255055276--