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 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

Error: 500 OOPS: vsftpd: refusing to run with writable root inside chroot() [SOLVED]

The Fix This error may occur when attempting to connect to a vsftpd FTP server that is...

How to Install Logwatch on Fedora 20

Logwatch is a Perl-based log management tool for analyzing, summarizing, and reporting on a...

How to List Compiled PHP Modules from Command Line

Pre-Flight Check These instructions are intended specifically for listing compiled PHP modules...

How to Upgrade MySQL 5.1 to MariaDB 10.0 on CentOS 6

Step #1: Upgrade from MySQL 5.1 to MariaDB 5.5 The proper upgrade path from MySQL 5.1 to MariaDB...

How to Install mlocate (locate and updatedb Commands) on CentOS 6

One of the best tools for quickly finding files by filename is the locate command. The locate...

Powered by WHMCompleteSolution