How To Install PostgreSQL on Windows
How To Install PostgreSQL on Windows
PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched.
This blog post is a very simple wizard run-through of installing PostgreSQL and Stack Builder on Windows for testing.
# Install PostgreSQL on Windows
# Install Stack Builder on Windows
Install PostgreSQL on Windows
PostgreSQL official downloads can be found here. Also see this link (chapter 16) for installing this on a Linux system.
1. Run set-up exe file.
![PostgreSQL Install Wizard - Setup.](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_wiz1.png)
2. Specify installation directory.
![](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_wiz_inst_dir.png)
3. Select features.
![PostgreSQL Components](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_compon.png)
4. Specify data directory.
![PostgreSQL Install - Data Directory](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_data_dir.png)
5. Enter the superuser (postgres) password.
![Set Postgres Superuser Password](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_rpass.png)
6. Enter the listening port.
![PostgreSQL Port Number](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_port.png)
7. Default local for English.
![PostgreSQL Locale Settings](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_locale.png)
8. Next, next, next & you’re done.
![PostgreSQL Install Summary](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_summary.png)
![Postgres Install Windows](https://peter-whyte.com/wp-content/uploads/2018/05/pgsql_rdy.png)
Install Stack Builder Components on Windows
Stack Builder is a quick way of getting additional software installed on your server, such as drivers, apache and EnterpriseDB tools.
1. Select your Postgres Sever.
![Stack Builder Install](https://peter-whyte.com/wp-content/uploads/2018/05/stack_builder_1.png)
2. Make your selections – pretty handy having things like the drivers in here.
![Stack Builder Applications List](https://peter-whyte.com/wp-content/uploads/2018/05/stackbuilder_applications_list.png)
3. Continue on.
![Stack Builder Install Wizard](https://peter-whyte.com/wp-content/uploads/2018/05/stack_builder_next.png)
4. A reboot may be required, depending on what has been selected.
![Stack Builder Install Reboot Required](https://peter-whyte.com/wp-content/uploads/2018/05/stack_builder_reboot.png)
And we’re done. Next, install a management tool such as PG Admin.
2 Comments
[…] you’re like me and you forget what you set the postgres user password to during the install, what do you do? I blame it on being human, but it’s a test environment, so it’s a good thing […]
[…] Install SQL Server (separate post).# Install PostgreSQL (separate post).# Test Connectivity to Remote Server (previous Linked Server post).# Create Linked […]