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.