| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: recovering from backup + transaction log |
| Date: | 2003-11-20 11:29:06 |
| Message-ID: | 20031120112906.GC9384@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oli Sennhauser | 2003-11-20 16:09:41 | Backup/Recovery (BR) question |
| Previous Message | rm_pg | 2003-11-20 08:48:04 | cancel <3FBC7DA1.3000209@cheapcomplexdevices.com> |