programatically install postgres on windows
Of course if you are running a PostgreSQL server it should be on a robust *NIX server, as that is what PostgreSQL is natively written for.
However some of our teams need Windows servers, and on these they need the
client to communicate with remote databases.
To install PostgreSQL (client) on Windows with a GUI installer is easy. Download installer, click "Next" a few times, and it's installed.
However to install programatically through a DSC system requires a little more work.
Luckily, PostgreSQL provides the binaries
and related tools.
However for a fresh install of Windows, these won't work out of the box.
First, you will then need to install
Microsoft Visual C++ 2013 Redistributable
. This will install all the required DLLs.
If using Chocolatey (if not, start!) -
choco install -y msvisualcplusplus2013-dist
Then, download the zipped PostgreSQL directory and then move the
directory into a common location, such as
Finally, add the binaries to your
with your desired DSC framework.
windows_path 'C:\Program Files\pgsql\bin' do
You will now be able to use the PostgreSQL binaries from your PowerShell and CMD prompts.last updated 2019-02-18T15:56:19+0000