On Thu, 2005-08-04 at 10:56 +0800, Qingqing Zhou wrote: > "Tom Lane" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org