How To Install and Use PostgreSQL on Ubuntu

Since we haven't updated our local apt repository lately, let's do that now. We can then get the Postgres package and a "contrib" package that adds some additional utilities and functionality:

$sudo apt-get update
$sudo apt-get install postgresql postgresql-contrib

The installation procedure created a user account called `postgres` that is associated with the default Postgres role. In order to use Postgres, we'll need to log into that account. You can do that by typing:

$sudo -i -u postgres

You will be asked for your normal user password and then will be given a shell prompt for the postgres user.

You can get a Postgres prompt immediately by typing:

$psql

Exit out of the PostgreSQL prompt by typing:

$\q

PostgresSQL In UI Mod

Step 1 - Installing PostgreSQL, phpPgAdmin and Apache2

PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.

$sudo apt-get -y install postgresql postgresql-contrib phppgadmin

Step 2 - Configure PostgreSQL user

PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called "postgres" for basic authentication. To use PostgreSQL, you need to login to the "postgres" account, you can do that by typing:

$sudo su

$su - postgres

Now you can access the PostgreSQL prompt with the command:

$psql

And then change the password for postgres role by typing:

$\password postgres

ENTER YOUR PASSWORD

Then enter \q to leave the psql command line.

Run the command "exit" to leave the postgres user and become root again.

$exit

Step 3 - Configure Apache2

You need to configure apache for phpPgAdmin. Edit the file /etc/apache2/conf-available/phppgadmin.conf with nano by typing:

$cd /etc/apache2/conf-available/

nano phppgadmin.conf

Comment out the line #Require local by adding a # in front of the line and add below the line allow from all so that you can access from your browser.