On Thu, 2005-08-04 at 10:56 +0800, Qingqing Zhou wrote:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes
> > > Since there is no xlog replay mechanism to CREATE INDEX (bottom-up
> method),
> > > so CREATE INDEX won't get replayed in PITR?
> >
> > On what do you base either part of that statement?
I have learnt that Tom means: read the code. :-)
CREATE INDEX doesn't produce xlog records *except* when you use PITR, so
PITR does work correctly.
Tom's earlier warning about CREATE DATABASE stands...
Best Regards, Simon Riggs