How to Install and Connect to PostgreSQL on Ubuntu 12.04

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.

apt-get -y update

Then it’s a matter of just running one command for installation via apt-get:

apt-get -y install postgresql postgresql-contrib

Postgres should now be installed and ready to use.

Step 2: Switch to the Default PostgreSQL User

As part of the installation Postgres adds the system user <reference_page_text>postgres and is setup to use “ident” authentication. Rolesinternal 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 <reference_page_text>postgres role):


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

  • 0 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

İlgili diğer dökümanlar

Linux Process Statuses

When using ps with the “u” flag (ps -u) you will see a column called STAT that displays the...

How to Setup Email on Microsoft Outlook 2013

Step 1: Add a New Account Click Add Account.     Step 2: Select Manual Setup...

Scenario: Set Up a Default Configuration Webserver and Limit Access

Step 1: Install Apache (httpd) yum -y install httpdservice httpd startchkconfig httpd on Step...

How to Create a Self-signed SSL Certificate on Ubuntu

An SSL certificate is an electronic ‘document’ that is used to bind together a public...

How to Install and Configure phpMyAdmin on CentOS 7

Step 1: Add the EPEL Repository phpMyAdmin is part of Extra Packages for Enterprise Linux...

Powered by WHMCompleteSolution