[Pgpool-general] online recovery by PITR - broken examples?

[Tomasz Chmielewski]

Jaume Sabater wrote:
> On Mon, Oct 26, 2009 at 5:59 PM, Tomasz Chmielewski <mangoo at wpkg.org> wrote:
> 
>> Is it the same as "/data" referenced later? Probably yes.
> 
> It is.
> 
>> Anyway, I can't get it to work.
> 
> It proved very useful to me in order to create mine, but I did not
> expect it to work out of the box. Nor should you. It's meant to be an
> example for you to learn, just that. It's a script that works on
> Tatsuo's laptop, but just that.
> 
>> Does anyone have online recover with pgpool-ii explained in more details?
> 
> http://linuxsilo.net/articles/postgresql-pgpool.html#base-backup

Yes, this is what I don't understand - these scripts seem to want to 
copy the whole postgresql data directory. That can't be right, can it?

With 10 GB database, how long will the recovery take? What if the 
database is even bigger?


-- 
Tomasz Chmielewski
http://wpkg.org