This repository is archived!
I no longer have a need for PostgreSQL as a Windows container so I will not continue to maintain this repository.
If anyone still has a use case for this kind of container image I recommend to reimplement the refactored upstream entrypoint shell script in PowerShell. Batch script probably cannot be used without a lot of ugly hacks.
Supported tags and Dockerfile links
12.0,12,latest(12/Dockerfile)11.5,11(11/Dockerfile)10.10,10(10/Dockerfile)9.6.15,9.6(9.6/Dockerfile)9.5.19,9.5(9.5/Dockerfile)9.4.24,9.4(9.4/Dockerfile)
The above tags are manifest tags that consist of a set builds based on all available nanoserver releases, specifically:
nanoserver:1909nanoserver:1903nanoserver:1809nanoserver:1803(EOL 2019-11-12)nanoserver:1709(EOL 2019-04-09)nanoserver:sac2016(EOL 2018-10-09)
Your Docker client should pull down the correct image.
Quick reference
-
Where to get help: the Docker Community Forums, the Docker Community Slack, or Stack Overflow
-
Where to file issues: https://github.com/stellirin/docker-postgres-windows/issues
-
Maintained by: Stellirin
-
Supported architectures: (more info)
windows-amd64
What is PostgreSQL?
How to use this image
$ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d stellirin/postgres-windowsThis image includes EXPOSE 5432 (the postgres port), so standard container linking will make it automatically available to the linked containers. The default postgres user and database are created in the entrypoint with initdb.
Extended use
For further details about usage see the official PostgreSQL container image.
About this container image
A Windows container to run PostgreSQL based on the EnterpriseDB distribution, which is found on the PostgeSQL for Windows download page.
This repository builds a Windows based Docker image that is functionaly similar to the official Linux based Docker image.
Testing
The resulting image has been (minimally) tested with a proprietary enterprise Java application. This image accepts typical SQL files, it can use TLS certificates in PEM format, and it allows the Java application to connect securely and process data.
So far, no differences in behaviour have been observed compared to the official Linux based container.
Motivation
The Linux based Docker image cannot run on Windows as a LCOW container. This is due to differences in functionality between the NTFS and EXT4 file systems. Specifically, Linux commands such as chown do not work but the PostgreSQL images rely on them for security.
Entrypoint
The entrypoint is written as a batch script because the database is run on windows/nanoserver, which doesn't have PowerShell. Writing the entrypoint script was challenging due to batch script limitations, but this gives us a base image of less than 450MB versus nearly 5GB when windows/servercore is used.
The Dockerfile and the docker-entrypoint.cmd were strongly inspired by the equivalent files for the official Linux based Docker images. There are some minor deviations, but this is mostly to work around differences in batch script behaviour.
Licence
The files here are under the MIT licence, the same as the regular docker-library/postgres docker files. Just like docker-library/postgres, the licence here covers only the files in this repository. It doesn't cover the PostgreSQL distribution, which has its own licence.