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):

psql


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 utilizatori au considerat informaţia utilă
Răspunsul a fost util?

Articole similare

How to Check POP3 Email with Gmail

Step 1: Go to Account Settings Click on the ‘settings’ button.    ...

How to Install and Connect to PostgreSQL on CentOS 7

Step 1: Add the PostgreSQL 9.3 Repository In this case we want to install PostgreSQL 9.3...

chkconfig Command Examples for Red Hat and CentOS

View Full List of Services Using chkconfig chkconfig --list View Full List of Services That...

How to Check the glibc (GNU libc) Version on CentOS 6 and CentOS 7

Using ldd ldd --version This should return a result similar to: ldd (GNU libc) 2.17Copyright...

How To Install Git on Ubuntu 14.04

Introduction Git is an open source, distributed version control system (VCS). It’s...

Powered by WHMCompleteSolution