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 s=
lot then try to restart the server. The server will refuse to start.=20

I checked the file it was not read only. There is nothing I could do to the f=
ile or the directory to succeed in restarting pg.

I put fsync=3Doff and I could start pg. but this is not a good permanent sol=
ution!

Envoy=C3=A9 de mon iPad

> Le 2015-04-27 =C3=A0 12:00, Alvaro Herrera <alvherre@2ndquadrant.com> a =C3=
=A9crit :
>=20
> 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).
>>=20
>> Patrice has since replied with log_error_verbosity=3Dverbose logs, but
>> that reply is probably still stuck in moderation:
>=20
> Ah, sorry about that.  Approved.
>=20
>> 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.
>=20
> Ah, fsync_fname() explicitely defends against this.
>=20
>> So that's easy enough fixed.
>=20
> Nice.
>=20
> --=20
> =C3=81lvaro Herrera                http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services