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

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Hans Buschmann <buschmann@nidsa.net>
Cc: Andres Freund <andres@anarazel.de>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>, Michael Paquier <michael.paquier@gmail.com>
Date: 2019-10-06T05:00:11Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Flush logical mapping files with fd opened for read/write at checkpoint

  2. Use a fd opened for read/write when syncing slots during startup, take 2.

  3. Tighten use of OpenTransientFile and CloseTransientFile

  4. Use a fd opened for read/write when syncing slots during startup.

On Sat, Oct 05, 2019 at 07:40:00AM +0000, Hans Buschmann wrote:
> Thanks for the quick fix. I reported it immediately to get it soon
> fixed before 12.1.

Sorry that you got annoyed by that :/
You can blame me about it..

> 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.

There is documentation on the matter:
https://www.postgresql.org/docs/devel/install-windows-full.html#id-1.6.4.8.10

> It would be VERY helpful 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.

I think that this would be difficult, per licensing issues and such,
no?  The maintenance of such a tarball would be annoying as well, for
example OpenSSL version changes quite often and needs to be bundled
with the installer so as DLLs loading it are able to work.
--
Michael