Tuesday, July 3, 2018

Step By Step Installation PostgreSQL server on Windows

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.

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



clip_image001

Specify installation folder, choose your own or keep the default folder.

clip_image002

Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.

clip_image003

Choose the default locale used by the database.

clip_image004

You completed providing information for the PostgreSQL installer. Click the Next button.

The installation may take few minutes to complete.

clip_image005

Click the Finish button to complete the PostgreSQL installation.

Verify the Installation

First, click on pgAdmin III to launch it. The pgAdmin III GUI will display.

clip_image006

clip_image007

Second, double click on PostgreSQL 9.5 on the object browser. It will ask you for the admin password. Just enter the password you’ve used in the installation step.

clip_image008

pgAdmin will display all the objects that belong to the server.

clip_image009

Congratulation! you’ve successfully installed PostgreSQL database server.

No comments:

Post a Comment

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...