Re: BUG #14125: when master set tablespace,slave recovery xlog pending

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: wangyong20009109(at)163(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14125: when master set tablespace,slave recovery xlog pending
Date: 2016-05-04 11:43:11
Message-ID: CAB7nPqRjnMTiNWFd+orOKJEQ27yEt0Os0KHb=kCQcvLWaXWnvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, May 4, 2016 at 4:26 PM, <wangyong20009109(at)163(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14125
> Logged by: YongWang
> Email address: wangyong20009109(at)163(dot)com
> PostgreSQL version: 9.4.5
> Operating system: Red Hat 4.8.2-16
> Description:

> when master alter database set tablespace,the slave(async replication)
> recovery xlog is pending,the slave normal receiver xlog.

Is the slave complaining about something in its logs? Also, do you
have unlogged relations on this database? We fixed in 9.4.6 a problem
with ALTER TABLE SET TABLESPACE that was not emitting correctly WAL
records. I cannot reproduce the problem to be honest, so you may want
to retry with 9.4.7 first, which is the last released version in the
9.4 series.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Pacejo 2016-05-04 12:09:34 Re: BUG #14064: Sort order of bytea, etc. not defined
Previous Message Thom Brown 2016-05-04 10:42:40 Re: [BUGS] Breakage with VACUUM ANALYSE + partitions