- download zipped binaries - [https://www.enterprisedb.com/download-postgresql-binaries](https://www.enterprisedb.com/download-postgresql-binaries)
- implement folder structure: `pgsql`, `data`, `scripts`, `logs`, `start.bat`, `stop.bat`
- add binary location to PATH
- initialise database
  - this will update directory permissions and create config files

```shell
initdb -D "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\data" -U postgres
```

Start script:

```bat
@echo off
cd /d "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\pgsql\bin"
pg_ctl -D "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\data" -l "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\logs\postgres.log" start
pause
```

Stop script:

```bat
@echo off
cd /d "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\pgsql\bin"
pg_ctl -D "C:\Users\lmiloszewski\dev_programs\postgres\17.6-1\data" stop
pause
```

Installing extensions:

- postgres extensions manager
  - [https://github.com/pgxman/pgxman](https://github.com/pgxman/pgxman)
- visual studio developer command prompt - [https://learn.microsoft.com/en-us/visualstudio/ide/reference/command-prompt-powershell?view=vs-2022](https://learn.microsoft.com/en-us/visualstudio/ide/reference/command-prompt-powershell?view=vs-2022)

Setting up postgres locally on Windows