Re: Need solution for weekly database "snapshot"

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pgsql-general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need solution for weekly database "snapshot"
Date: 2013-04-22 17:41:13
Message-ID: 66950564-1F87-4E95-A1A6-22F6794AA950@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 22, 2013, at 10:05 AM, Moshe Jacobson wrote:
> Not bad, but the transaction logs would fill up the file system.

I'm not sure I understand that comment. Why would the transaction logs be particularly voluminous in this case?

> Besides, it would not be worth it to set up a whole database cluster just for this purpose.

It does seem to meet all of your needs in a very efficient way; setting up a PG cluster is not that complex.

--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-04-22 17:59:28 Re: Need solution for weekly database "snapshot"
Previous Message Steven Schlansker 2013-04-22 17:37:26 Using an index for IS DISTINCT FROM queries