{"repo":"darianmiller/install-postgres-on-windows","free":true,"listed":false,"github":"https://github.com/darianmiller/install-postgres-on-windows","clone":"git clone https://github.com/darianmiller/install-postgres-on-windows.git","description":"Simple PowerShell script to install PostgreSQL from a binary release zip on Windows (with option to download latest version from EDB)","language":"PowerShell","stars":17,"topics":["postgresql","powershell"],"license":null,"category":"databases-storage","readme_excerpt":"install-postgres-on-windows PowerShell script to install PostgreSQL from a binary release zip on Windows. - No dependencies - MIT Licensed - Automatically downloads the latest binary release zip for Windows from EDB: https://www.enterprisedb.com/download-postgresql-binaries - Associated blog article can be found here: https://ideasawakened.com/post/2024-02-03-setup-postgresql-on-windows-from-zip Summary You can simply run the script with the DownloadLatest switch ( Install-Postgres-On-Windows.ps1 -DownloadLatest ) and the latest release zip will be downloaded, then automatically installed to C:\\Postgres , and you will end up with a new Windows Service named Postgres actively running and accepting all local connections on port 5432. Alternately, manually download the latest release zip and provide it via the ArchiveFileName parameter. ( Install-Postgres-On-Windows.ps1 -ArchiveFileName postgresql-16.1-1-windows-x64-binaries.zip ) Parameters Note: you need to provide at least one parameter as you must either specify the ArchiveFileName or the DownloadLatest switch. ArchiveFileName This string parameter is the release zip to install (as previously downloaded from EDB.) An example of the current latest release zip is postgresql-16.1-1-windows-x64-binaries.zip which is 330MB in size. DestinationPath This optional string parameter is the path to unzip the binaries into and it defaults to C:\\Postgres if not provided. In a full installation, there will be three child folders created: ","default_branch":null,"files":null,"tree":[],"storefront":"/r/darianmiller","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/darianmiller/install-postgres-on-windows/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}