How to Install and Connect to PostgreSQL on CentOS 6

Cpanel/Whm License $3/mo Plesk License $10/mo Cloudlinux License $5/mo

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.

Pre-Flight Check
  • These instructions are intended specifically for installing PostgreSQL on CentOS 6.
  • I’ll be working from a sxi.io Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Step 1: Install PostgreSQL

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.

Step 2: Start PostgreSQL

Configure Postgres to start when the server boots:

chkconfig postgresql on

Start Postgres:

service postgresql initdb

service postgresql start

Step 3: Switch to the Default PostgreSQL User

As part of the installation Postgres adds the system user postgres and is setup to use “ident” authentication. Roles internal to Postgres (which are similar to users) match with a system user account.

Let’s switch into that system user:

su – postgres

And then connect to the PostgreSQL terminal (in the postgres role):

psql

That’s it! You’re connected and ready to run commands in PostgreSQL as the postgres role. In future (Sept 2014) articles we’ll delve into creating new roles, changing a role’s password, creating/deleting databases, backups, etc.

Related posts

Safello Partners with UK Bank for Faster Payments

SXI ADMIN

Gyft to Embrace ‘Radical’ Blockchain Concept in Gift Card Fraud Fight

SXI ADMIN

Bitcoin Miners Send Message at Fidelity: We Run on Clean Energy, Not Dirty Coal

SXI ADMIN

Coinbase: ‘Longest Chain’ Likely to Decide Ethereum Support

SXI ADMIN

Rapper Soulja Boy Brags About Bitcoin Gains in New Rap Track

SXI ADMIN

Why Project Indy is Using Hybrid DLT to Rethink Digital Identity

SXI ADMIN

BitFunder Operator ‘Close to’ Plea Bargain in SEC Fraud Case

SXI ADMIN

Santander: Blockchain Tech Can Save Banks $20 Billion a Year

SXI ADMIN

Equity Markets on a Blockchain: Delaware’s Potential Impact

SXI ADMIN

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More