PostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is commonly used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.
- These instructions are intended specifically for installing PostgreSQL on CentOS 6.
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.
yum -y update
Then it’s a matter of just running one command for installation via yum:
yum -y install postgresql postgresql-contrib
PostgreSQL should now be installed.
Configure Postgres to start when the server boots:
chkconfig postgresql on
service postgresql initdb
service postgresql start
As part of the installation Postgres adds the system user
Let’s switch into that system user:
su – postgres
And then connect to the PostgreSQL terminal (in the
That’s it! You’re connected and ready to run commands in PostgreSQL as the