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 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

Error: Failed to connect to ’127.0.0.1:7199′: Connection refused (Cassandra) [SOLVED]

Error While Using Cassandra’s ‘nodetool’ This error may occur when using the ‘nodetool’ command,...

What is an SPF Record?

An SPF (Sender Policy Framework) record is a list of servers that are allowed to send e-mail from...

What are the XWEBHosting Name Servers (NS)?

So let’s say your server is online, it has been secured with ServerGuard™, and...

How to Create and Add a New Domain in Plesk

Step #1: Add New DomainTo create a new domain in Plesk 11+ you will click on the Add New...

Monitoring Server Processes With Top

The top program provides a dynamic real-time view of a running system. It can display system...

Powered by WHMCompleteSolution