Basic postgresql server setup

“Installation

“The first thing you need to do is to install the necessary
software. Since this is Ubuntu, it’s quite easy. Open up a terminal
window and issue the command:

sudo apt-get install postgresql

“Once the software is installed you are ready to set it all
up.

Change the default user password

“One of the first steps you want to take is to change the
default password for the user postgres. Sine we are using Ubuntu
you will have to use the sudo command to change to the postgres
user like so:”

Complete
Story