Обсуждение: Point in Time Backups

As most DB's know to get full integrity in a backup you either have to
perform cold backups or have a point in time capable hot backup. If
Postgresql is truely useful as a production database you need a full
point in time backup and recovery system. I would consider using
Postgres for several commercial applications but, not at the expense of
losing my clients due to loss of data.

On Thu, Oct 17, 2002 at 06:47:23AM -0500, D. S. Johnson wrote:
> As most DB's know to get full integrity in a backup you either have to
> perform cold backups or have a point in time capable hot backup. If
> Postgresql is truely useful as a production database you need a full
> point in time backup and recovery system. I would consider using
> Postgres for several commercial applications but, not at the expense of
> losing my clients due to loss of data.

Point in time will apparently be available in 7.4; there's a patch
sitting queued up for just this purpose, but it wasn't ready in time
for the 7.3 feature freeze.

In the meantime, you can buy cheap insurance by replicating your
database.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110