ubuntu postgres install

Postgresql is one of the greatest database server. It can be installed in multiple platform, such as Linux, Windows, Solaris, FreeBSD, Mac OS X.On Ubuntu, postgres installation can be executed with command :

# apt-get install postgresql

#/etc/init.d/postgresql start ==> Start postgresql

To create username and password in postgres, you should login postgres, write :
#psql
then login as superuser
$su - postgres

To add user and password in postgres you can write in the simple way :
#adduser user_name
#passwd user_name

To connect with database, please type :
#\c database_name
#\i file_name ==> Extract database

For the other source, please click here