Re: Seeking datacenter PITR backup suggestions - Mailing list pgsql-general

From Decibel!
Subject Re: Seeking datacenter PITR backup suggestions
Date
Msg-id 20070829000349.GN1386@nasby.net
Whole thread Raw
In response to Re: Seeking datacenter PITR backup suggestions  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On Tue, Aug 28, 2007 at 11:05:52AM -0700, Steve Crawford wrote:
> In your scenario, what about using "cp -l" (or "ln") instead? Since the
> hard-link it is only creating a new pointer, it will be very fast and
> save a bunch of disk IO on your server and it doesn't appear that the
> tempdir is for much other than organizing purposes anyway.

Note that that will only work if you're creating the link on the same
filesystem, and having /tmp and your data in the same filesystem isn't
such a hot idea.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: Decibel!
Date:
Subject: Re: Seeking datacenter PITR backup suggestions