Re: [SPAM] Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot

From: Andres Freund <andres(at)anarazel(dot)de>
To: Patrice Drolet <pdrolet(at)infodata(dot)ca>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [SPAM] Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot
Date: 2015-04-27 22:22:37
Message-ID: 20150427222237.GA2658@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On 2015-04-27 12:50:32 -0400, Patrice Drolet wrote:
> On Windows, this is really easy to have this problem : create a replication slot then try to restart the server. The server will refuse to start.
>
> I checked the file it was not read only. There is nothing I could do to the file or the directory to succeed in restarting pg.
>
> I put fsync=off and I could start pg. but this is not a good permanent solution!

I've pushed a fix for this. It'll be included in the next 9.4 minor
release.

Thanks for the report!

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2015-04-28 00:19:36 Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message corey.huinker 2015-04-27 21:15:55 BUG #13179: pg_upgrade failure.