Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot
Date
Msg-id 20150427160015.GW4369@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot  (Andres Freund <andres@anarazel.de>)
Responses Re: [SPAM] Re: BUG #13143: Cannot stop and restart a streaming server with a replication slot  (Patrice Drolet <pdrolet@infodata.ca>)
List pgsql-bugs
Andres Freund wrote:
> On 2015-04-27 11:44:47 -0300, Alvaro Herrera wrote:
> > I think this is failing in the fsync_fname() call in slot.c line 1045
> > (REL9_4_STABLE).
>
> Patrice has since replied with log_error_verbosity=verbose logs, but
> that reply is probably still stuck in moderation:

Ah, sorry about that.  Approved.

> Hm. I wonder if it's maybe that the file is opened with O_RDONLY? The
> OSs I have access to don't care - for good reason imo, fsync isn't a
> write - but it's not inconceivable that windows might.

Ah, fsync_fname() explicitely defends against this.

> So that's easy enough fixed.

Nice.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: cees.van.zeeland@xs4all.nl
Date:
Subject: BUG #13168: DROP DATABASE does not clean up all references
Next
From: Marko Tiikkaja
Date:
Subject: Re: BUG #13160: Incorrect escaping of quotes in JSON export