AW: BUG #16039: PANIC when activating replication slots in Postgres 12.0 64bit under Windows

________________________________________
Von: Andres Freund <andres(at)anarazel(dot)de>
Gesendet: Freitag, 4. Oktober 2019 22:49
An: Hans Buschmann; pgsql-bugs(at)lists(dot)postgresql(dot)org; Michael Paquier
Betreff: Re: BUG #16039: PANIC when activating replication slots in Postgres 12.0 64bit under Windows

>If you want to work around the problem, you can, but it's not entirely
>unproblematic: If, just when restarting, you set fsync to false, you'll
>avoid the problem. But then you'd have to immediately re-enable
>afterwards, and there's still a small data loss window. If however all
>you want is to continue testing, fsync=off might be a reasonable
>workaround.

Hi Andres,

Thanks for the quick fix. I reported it immediately to get it soon fixed before 12.1.

In the meantime we continue to use pg 12 on the production System (quite confident in overall Software Quality!).

I can't reenable it because there may be unexpected restarts (power failures for example) and then the unattended restart would not succeed.

In quite a Long journey I have got deeper Knowledge of the whole System. So now I am able to recompile from source BUT:

It is VERY difficult to get the whole Environment under Windows!

I use Visual Studio Express 2019 (Version 16.3 from Oct 2019) and got the core (source tarball) compiled without error.

But I have not managed to get all the additional packages downloaded and adopted to the most recent Visual Studio (e.g zlib, XML, ssl etc.)

The Manual only states the Locations for download, but doesn't help in compiling.

It would be VERY helpfull to provide a .ZIP file for download on the Postgres Website containing all the additional packages in a usable Directory tree and some config file for compiling. This (mostly) should exist already for the buildfarm or for Building the release.

Because the upstream Software doesn't Change often, it would (as quick alternative) be sufficient to have the include files and the compiled libraries to easily compile Postgres from source.

Thanks for considering this proposal!

Hans Buschmann

PS Uppercase Problems are from the mail System!