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 Корисниците го најдоа ова како корисно
Дали Ви помогна овој одговор?

Понудени резултати

How to Display (List) All Jobs in Cron / Crontab

Servers can automatically perform tasks that you would otherwise have to perform yourself, such...

How to Install WordPress in cPanel / WHM with Softaculous

WordPress is a very popular option for running a website or blog and can be used to get your...

How to: Using killall to Stop Processes with Command Line

Sometimes you may find your server in a state of high load caused by out control of processes....

Error: (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80 on Ubuntu [SOLVED]

Option #1: Multiple ‘Listen’ Directive Entries in Configuration Files In some cases...

How to Disable SSLv3 for Exim and Protect Your WHM/cPanel Server from POODLE

There’s a new POODLE in town, but unfortunately it’s not the kind of pooch you want around....

Powered by WHMCompleteSolution