On Jan 22, 2004, at 10:00 AM, Cott Lang wrote:
> On Thu, 2004-01-22 at 07:38, lnd@hnit.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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/