Postgres installation on Ubuntu

https://help.ubuntu.com/community/PostgreSQL

1. Installing server locally

$sudo apt-get install postgresql postgresql-contrib

2. Administration using GUI tool pgAdmin3

$sudo apt-get install pgadmin3

3. Basic server setup

$sudo -u postgres psql postgres

\password postgres

Give password when prompted. Then type Control+D or \q to exit the posgreSQL prompt.

4. Create database

sudo -u postgres createdb <database-name>

5.Using pgadmin3 GUI tool

$pgadmin3

 

Rating: