How to install PostgreSQL in your local system for learning and practicing PostgreSQL.
PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as Mac OS X, Solaris, and Windows.
Download PostgreSQL Installer for Windows
You need to download the installer from PostgreSQL Official website.
- Go to the PostgreSQL official website, download section for Windows http://www.postgresql.org/download/windows/
Install PostgreSQL step by step
Click on the installer file, an installation wizard will appear
The following each step and its options for installation. Start Installing PostgreSQL
Specify installation folder, choose your own or keep the default folder.
Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.
Choose the default locale used by the database.
You completed providing information for the PostgreSQL installer. Click the Next button.
The installation may take few minutes to complete.
Click the Finish button to complete the PostgreSQL installation.
Verify the Installation
First, click on pgAdmin 13 to launch it. The pgAdmin 13 GUI will display.
Congratulation! you’ve successfully installed PostgreSQL database server.