Skip site navigation (1) Skip section navigation (2)

Re: Streaming replication, and walsender during recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming replication, and walsender during recovery
Date: 2010-01-18 14:31:22
Message-ID: 4745.1263825082@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> When I configured a cascaded standby (i.e, made the additional
> standby server connect to the standby), I got the following
> errors, and a cascaded standby didn't start replication.

>   ERROR:  timeline 0 of the primary does not match recovery target timeline 1

> I didn't care about that case so far. To avoid a confusing error
> message, we should forbid a startup of walsender during recovery,
> and emit a suitable message? Or support such cascade-configuration?
> Though I don't think that the latter is difficult to be implemented,
> ISTM it's not the time to do that now.

It would be kind of silly to add code to forbid it if making it work
would be about the same amount of effort.  I think it'd be worth looking
closer to find out what the problem is.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-01-18 14:34:27
Subject: Re: Hot Standby and handling max_standby_delay
Previous:From: Fujii MasaoDate: 2010-01-18 13:25:07
Subject: Re: New XLOG record indicating WAL-skipping

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group