PostgreSQL is another very good object-relational database management system. You may know others like SQL, ORACLE, MySQL etc. PostgreSQL is a open source database system. It is basically designed to run on UNIX like platforms. But as per the demand later on it designed to be portable, so that it could run on various platforms such as Mac OS X, Solaris and Windows.
Most Common features of PostgreSQL
- It has User-defined types.
- It has Table inheritance.
- It has Sophisticated locking mechanism.
- It has Foreign key referential integrity.
- It has Views, rules, sub-select.
- It has Nested transactions (save points).
- It has Multi-version concurrency control.
- It has Asynchronous replication.
There are two steps to complete the PostgreSQL installation
- Download PostgreSQL installer for Windows
- Install PostgreSQL
Download PostgreSQL Installer for Windows
You need to download the installer, go to the
PostgreSQL official website, then go to the download section for
Windows or you can just click on this
Link - Click on the download installer from EnterpriseDB.
- Choose the latest version to download. It takes few minutes to complete the download.
Install PostgreSQL Step by Step
Double click on the installer file, an installation wizard will appear and guide you through multiple steps where you can choose different options that you would like to have in PostgreSQL.
The following illustrates each step and its options for installation. If you install a different version, you may get additional steps.
Step 1: Start Installing PostgreSQL
Step 2: Specify installation folder, choose your own or keep the default folder suggested by PostgreSQL installer.
Step 3: Enter the password for the database superuser and service account.
Step 4: Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.
Step 5: Choose the default locale used by the database.
Step 6: You’ve completed providing information for the PostgreSQL installer. Click the Next button to install PostgreSQL
The installation may take few minutes to complete.
Click the Finish button to complete the PostgreSQL installation.