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

Hi,

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!

Envoyé de mon iPad

> Le 2015-04-27 à 12:00, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> a écrit :
>
> 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