Installing PostgreSQL and pgAdmin on Ubuntu

Tuesday, June 5, 2018

Installing PostgreSQL and pgAdmin on Ubuntu

Installation Tutorial

Firstly install the database package:

$ sudo apt-get install postgresql

Now pgAdmin; a simple interface to manage your database:

$ sudo apt-get install pgadmin3

Once the installation has finished, it's time to set up a password for the main account; you'll log in to postgresql:

-->> The version of postgres may vary slightly depending upon the Ubuntu version

$ sudo -u postgres psql postgres
psql (9.1.10)
Type "help" for help.

And then type \password postgres, and you'll be prompted for your password:

postgres=# \password postgres

Then write your password in. (If you can't see what you type, it's ok, this is for security reasons). Now type \q to exit postgres command-line interface:

postgres=# \q

Install Server Instrumentation
It's a package containing extra tools that help you manage your database. It's pretty much commonplace so I suggest you install it:

$ sudo apt-get install postgresql-contrib

Running pgAdmin

When you first open pgAdmin, you must Register a new Server (i.e.,create a new connection): first image

Some information will have been filled out for you. Set "localhost" as host, choose a name for your server, write "postgres" as username and write the password you've set in the previous steps for password:
second-image