How To Install PostgreSQL on Ubuntu 12.04
Step 1: Before postgres install, we should quick perform a quick update. apt-get update Step 2: Now install Postgres using the command line. sudo apt-get install postgresql postgresql-contrib This will install the latest version available in your Ubuntu. Step 3: Install the client sudo apt-get install postgresql-client Step 4: For a handy GUI for PostgreSQL install pgAdmin III. sudo apt-get install pgadmin3 Step 5: We need to change the PostgreSQL postgres user password; sudo -u postgres psql postgres Set a password for the "postgres" database role using the command: \password postgres Step 6: Exit from Postgres \q That's it we are done with the installation.