Tuesday, October 16

PGInstaller – A Step by Step Guide to install PostgreSQL

Here’s a step by step guide to install PostgreSQL on your machine using PGInstaller. PGInstaller supports three modes of installation; Graphical, Unattended and Text. We’re going to cover all three of them in this guide.

PGInstaller

To Install PostgreSQL via Graphical Mode

Step 1:

Download PGInstaller herePGInstaller is available for PostgreSQL 9.5, 9.6, 10, and 11(beta).

Step 2:

Click on the executable file to run the installer.

Step 3:

Select your preferred language.

PGInstaller GUI installer, install postgresql

Step 4:

Specify directory where you want to install PostgreSQL.

Step 5:

Specify PostgreSQL server port. You can leave this as default if you’re unsure what to enter.

Step 6:

Specify data directory to initialize PostgreSQL database.

Step 7:

Create a PostgreSQL user password.

Step 8:

Create password for database Superuser.

Step 9:

Click next to begin PostgreSQL installation.

The readme file contains installation paths, service names and database credentials.

To Install PostgreSQL via Unattended Mode

Navigate to the directory that contains PGInstaller and enter:

Windows:

PostgreSQL-10.4-1-windows-installer.exe /q

OSX:

PostgreSQL-10.4-1-osx-installer.app/Contents/MacOS/installbuilder.s –mode unattended –superuser_password database_superuser_password

Linux:

PostgreSQL-10.4-1-osx-installer-2.app/Contents/MacOS/installbuilder.s –mode unattended –superuser_password database_superuser_password

To Install PostgreSQL via Text Mode

Navigate to the directory that contains PGInstaller and enter:

For Windows

PostgreSQL-10.4-1-windows-installer.exe –mode text

For OSX

PostgreSQL-10.4-1-osx-installer.app/Contents/MacOS/installbuilder.sh –mode text

For Linux

PostgreSQL-10.4-1-linux-x64-installer.run –mode text

Space requirements

For the complete PGInstaller installation you will need approximately 60 mb of disk space.

Supported Platforms

Linux

Windows

OSX

  • RHEL6 and RHEL7

  • CentOS6 and CentOS7

  • Ubuntu Bionic, Xenial and Trusty

  • Fedora 25, Fedora 26

  • OpenSUSE 13.x

  • Debian Stretch and Jessie

  • Windows 8

  • Windows 10

  • 10 and above

For feedback or queries related to PGInstaller, email us at [email protected].

Leave a Reply

Your email address will not be published. Required fields are marked *