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.
