Postgres - Install on Ubuntu

Hi,
here's a simple tutorial on how to install PostgreSQL on Ubuntu.

My current version is a xubuntu 15.10 just installed.

The installation is very simple. Just type on a shell the following command:

sudo apt-get install postgresql pgadmin3

that installs the latest PostgreSQL version available (9.4.5) and the pgAdmin3 III client).

This installation does not require the creation of any password, so you must create it right after.
To set the password is necessary to access the console psql postgres; this is possible if you are logged in as postgres linux user. The procedure is the following:

• Open a shell typing the following command:

sudo su
su postgres
psql -U postgres -p 5432

•  Now you can set the password with the following query:

ALTER USER postgres WITH password 'mypassword';

• If you wanna create another user, you can use the following command:

CREATE ROLE thedumb LOGIN PASSWORD 'mypassword' CREATEDB VALID UNTIL 'infinity';

• Now type \q to exit from the psql console

By

TeD