Skip to content

Instantly share code, notes, and snippets.

@cameronelliott
Last active December 8, 2018 22:00
Show Gist options
  • Save cameronelliott/e9d778502cf44ff8793d8ddef7cab143 to your computer and use it in GitHub Desktop.
Save cameronelliott/e9d778502cf44ff8793d8ddef7cab143 to your computer and use it in GitHub Desktop.
Install postgres 11.1 on windows with crc on blocks
unzip postgresql-11.1-1-windows-x64-binaries.zip to \ which leaves pgsql in root
cd \pgsql\bin
mkdir \pgsql\data
mkdir \pgsql\log
initdb -k -U postgres -A password -E utf8 -W -D \pgsql\data
# as administrator
\pgsql\bin\pg_ctl.exe register -N "postgresql" -U "NT AUTHORITY\NetworkService" -D "\pgsql\data" -l "\pgsql\log\pgsql.log" -w
# maybe helpful to fix perms
icacls \pgsql\data /inheritance:r /grant:r BUILTIN\\Users:(OI)(CI)F
icacls \pgsql\bin\log /inheritance:r /grant:r BUILTIN\\Users:(OI)(CI)F
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment