Home / server / Questions / 772972
In Process
EM0
Asked: 2016-04-27 03:39:45 +0800 CST

Unattended install of PostgreSQL 9.5 on Windows, modifying config files

  • 772

I'd like to perform an unattended installation of PostgreSQL 9.5 on a number of Windows 7 machines, ideally by assigning an MSI via Group Policy. There seems to be no MSI file, but the EnterpriseDB EXE installer supports "--mode unattended". That should be workable, but I also want to change some options in postgresql.conf and pg_hba.conf (to enable SSPI authentication, for example). What's the easiest way to do this? Is there a way I can edit the files inside the installer EXE, for example? (7-zip fails to extract it.) Or do I have to write my own script to modify the config files and restart the service afterwards?

windows installation automated-install postgresql unattended

1 Answers

  1. I would recommend using a Configuration Management tool, like Ansible or Rex to connect to the machines (via SSH) after the install and update the config files.

    This allows you to manage changes better in the future, and keep the configs in source control.

    • 0