Installing PostgreSQL on Linux/Unix

Follow the given steps to install PostgreSQL on your Linux machine. Make sure you are logged in as root before you proceed for the installation.

• Pick the version number of PostgreSQL you want and, as exactly as possible, the platform you want from EnterpriseDB
• I downloaded postgresql-9.2.4-1-linux-x64.run for my 64 bit CentOS-6 machine. Now, let us execute it as follows −

[root@host]# chmod +x postgresql-9.2.4-1-linux-x64.run

[root@host]# ./postgresql-9.2.4-1-linux-x64.run

------------------------------------------------------------------------

Welcome to the PostgreSQL Setup Wizard.

------------------------------------------------------------------------

Please specify the directory where PostgreSQL will be installed.

Installation Directory [/opt/PostgreSQL/9.2]:

• Once you launch the installer, it asks you a few basic questions like location of the installation, password of the user who will use database, port number, etc. So keep all of them at their default values except password, which you can provide password as per your choice. It will install PostgreSQL at your Linux machine and will display the following message −

Please wait while Setup installs PostgreSQL on your computer.

 Installing

 0% ______________ 50% ______________ 100%

 #########################################

-----------------------------------------------------------------------

Setup has finished installing PostgreSQL on your computer.

• Follow the following post-installation steps to create your database −

[root@host]# su - postgres

Password:

bash-4.1$ createdb testdb

bash-4.1$ psql testdb

psql (8.4.13, server 9.2.4)

test=#

• You can start/restart postgres server in case it is not running using the following command −

[root@host]# service postgresql restart

Stopping postgresql service:                               [  OK  ]

Starting postgresql service:                               [  OK  ]

• If your installation was correct, you will have PotsgreSQL prompt test=# as shown above.