Re: Fundamental error in "no WAL log" index/file creation stuff - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Fundamental error in "no WAL log" index/file creation stuff
Date
Msg-id 20050626174650.GZ89438@decibel.org
Whole thread Raw
In response to Re: Fundamental error in "no WAL log" index/file creation stuff  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Would it be possible to rollback from WAL? My thought is this:

CREATE DATABASE is logged in WAL
If a replay of that CREATE DATABASE is performed, the template database
used is copied
Any modifications to the template database that occured after the CREATE
DATABASE are rolled back in the new database
WAL replay continues

Would this resolve the PITR issues with CREATE DATABASE?
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 changes need backpatching?
Next
From: "Denis Lussier"
Date:
Subject: Implementing SQL/PSM for PG 8.2