Re: recovering from backup + transaction log - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: recovering from backup + transaction log
Date
Msg-id 20031120112906.GC9384@libertyrms.info
Whole thread Raw
In response to recovering from backup + transaction log  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-admin
On Wed, Nov 19, 2003 at 05:17:27PM +0000, Gary Stainburn wrote:
>
> Is it possible to recover a database from a dump + some form of
> transaction log, i.e. if I pg_dump on a nightly basis, and then at
> noon the database crashes, can I take the last dump and roll it
> forward from a log.

No.

> (Is this to do with the recent Point-in-time recovery, and if so,
> will we have to wait for 7.5?)

Yes.

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


pgsql-admin by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Postgresql DB on a live cd
Next
From: Oli Sennhauser
Date:
Subject: Backup/Recovery (BR) question