From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
---|---|
To: | Cott Lang <cott(at)internetstaff(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: tablespaces a priority for 7.5? |
Date: | 2004-01-22 15:42:09 |
Message-ID: | 8A2529C5-4CF1-11D8-B47D-000393D1F76E@torgo.978.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 22, 2004, at 10:00 AM, Cott Lang wrote:
> On Thu, 2004-01-22 at 07:38, lnd(at)hnit(dot)is wrote:
>
>> Meaning incremental (hot)-backups?
>> Or as protection against DROP/TRUNCATE/DELETE ALL
>> TABLE/SCHEMA/DATABASE?
>>
>> With a WAL it should be doable in some 7.x version, all ingredients
>> are
>> there.
>>
>> Possibly someone suceeded in doing it already? Having a baseline
>> backup and
>> saved WAL logs, shouldn't it be possible to recover?
>
> Incremental pg_dumps would be a huge step in the right direction!
>
> However, unless I am mistaken, a baseline backup would need to be taken
> cold because you cannot take a consistent online backup of the data
> files without using file system snapshots or split mirrors, and even
> that's questionable.
>
pg_dump always takes a consistent dump - things won't change underneath
it.
So you're backup won't have anything that changed after pg_dump
started.. thus where incremental would come in.
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Keith C. Perry | 2004-01-22 15:42:46 | Re: embedded/"serverless" (Re: serverless postgresql) |
Previous Message | Martin_Hurst | 2004-01-22 15:36:32 | LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where is Postgresql |