Re: Fundamental error in "no WAL log" index/file creation stuff

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Greg Stark" <gsstark(at)mit(dot)edu>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fundamental error in "no WAL log" index/file creation stuff
Date: 2005-06-26 09:39:38
Message-ID: 00ee01c57a32$f8ab5a60$0f01a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark wrote:

> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
>> > (b) force a checkpoint
>> > immediately after any CREATE DATABASE, so that we never have to replay
>> > one except in a PITR situation
>
> So wouldn't this mean that any CREATE DATABASE won't work properly in
> PITR?

As I understand it: no. Because with PITR turned on there are no
"non-WAL-logged index
and table builds". Therefore the indexes and tables are WAL-logged and will
be recreated correctly.

I hope this is correct information :-)

Best Regards,
Michael Paesold

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2005-06-26 12:57:44 Re: Fundamental error in "no WAL log" index/file creation
Previous Message Hannu Krosing 2005-06-26 09:33:02 Re: Open items