Step1:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
choose Windows x86-64
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-19-1024x515.png)
The download is ~360Mb and should go to your browsers download folder,
postgresql-16.1-1-windows-x64.exe
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-20-1024x140.png)
Double click installer to begin installation.
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-21.png)
choose Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-22.png)
You can choose a different installation location, but if not accept defaults and Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-24.png)
Choose Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-25.png)
data is the main database data directory you can change this to store database in a different location, if not accept defaults Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-26.png)
Choose a memorable password for the superuser, for a test setup can use postgres as the password, then Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-27.png)
Accept default port unless a good reason to change then Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-28.png)
The local effects settings such as language, sorting, charactersets accept default unless reason to choose another.
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-29.png)
Review summary and then Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-30.png)
Choose Next>
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-31.png)
Software will now install allow 10 minutes to complete
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-32.png)
Can choose to launch Stack Builder wizard radio box then Choose Finish.
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-34.png)
You can choose extra components to install or simply Cancel, this does not impact Postgres as its already installed, this is to add extra features to Postgres.
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-35.png)
Start pgadmin4 from run menu
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-36.png)
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-37-1024x819.png)
Expand Servers tree and enter password chosen when installed for postgres superuser
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-38-1024x330.png)
expand tree for Postgres16 and choose postgres database, then click >_ tool to open up query IDE tool PSQL tool
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-39-1024x267.png)
you can now run command as you would in psql:
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-40-1024x543.png)
or use the more GUI friendly query tool (tools-> Query Tool)
![](https://www.snowdba.com/wp-content/uploads/2024/01/image-41-1024x543.png)
In postgres database run : create extension system_stats;
Now o/s stats from windows should be visible from Dashboard-> System Stats as well.