[Bug]: When performing a clean install on Windows, some files are missing for PG15

[benneharli]

What type of bug is this?

Unexpected error

What subsystems and features are affected?

Build system, Packaging, Platform/OS

What happened?

Refer to this post: https://timescaledb.slack.com/archives/C5X6UVB24/p1671581588175699

TimescaleDB version affected

2.9.0

PostgreSQL version used

15.1

What operating system did you use?

Windows 10

What installation method did you use?

Other

What platform did you run on?

On prem/Self-hosted

Relevant log output and stack trace

No response

How can we reproduce the bug?

1. Install PG 15 from EDB
2. Install TS 2.9.0

[svenklemm]

We test our package installation in CI and no files seem to be missing.
https://github.com/timescale/timescaledb/actions/runs/3768910545

You can find the code for the windows package test here: https://github.com/timescale/timescaledb/blob/main/.github/workflows/windows-packages.yaml

[benneharli]

Sorry, I guess I wasn't being 100% clear. The issue is as such not files missing in the TimescaleDB installer. You include the files you always did. The issue is, that you're relying on libraries, which are no longer included in the Windows installer from EnterpriseDB.

This happened "back then" as shown in the linked post. The error message is not that clear though.
https://timescaledb.slack.com/archives/C63MYDZ35/p1565685079085400

Link to installer: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Select the 15.1 installer

The files missing from the /bin directory are: libcrypto-1_1-x64.dll, libssl-1_1-x64.dll

You can copy those two from the /bin directory of a PG14 installation, and it then works.

So the issue is, that you either rely on libraries which are now deprecated in the installers delivered by EnterpriseDB, or that you liaise with EnterpriseDB to get the two files included again in their distribution.

[horzsolt]

@benneharli (and anyone who faces the same issue), the missing dependencies can be downloaded from here:
https://wiki.openssl.org/index.php/Binaries (if there is no existing PG14 instance available to copy the missing files from).

@svenklemm The tests passed as the image Github provides for Windows has OpenSSL 1.1.1 pre-installed. So it means we should update our Windows packaging for PG15. I will create an internal Github issue for this effort.

[mahipv]

Currently openssl 1.1.1 is a prerequisite on windows installation, it has been updated in the docs.
https://docs.timescale.com/self-hosted/latest/install/installation-windows/#prerequisites