Postgresql Environment Setup
Postgresql: PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Installation and configuration on Ubuntu 14.04 Step 1: $ sudo apt-get update Step 2: $ sudo apt-get install postgresql To connect the default Database: Step 3: sudo -u postgres psql template1 To create New user : template1>create user <user_name> with encrypted password '<pwd>'; Ex: create User Varun with encrypted password 'varun' To grant create database permission to new user: template1>ALTER USER <user_name> CREATEDB Ex : alter user Varun createdb Add new user in pg_hba.conf file with MD5 authentication Ed...