Tuesday, October 29, 2013

Install postgreSQL on ubuntu

Summary:
--------
Install postgreSQL database on ubuntu system

Step 1:
-------
Update your system.

$ sudo apt-get update

Step 2:
-------
Install postgresql and associated packages

$ sudo apt-get install postgresql postgresql-contrib


Step 3:
-------
We need to stop Postgres server.

$ sudo service postgresql stop

Step 4:
-------
Navigate postgres user. Change PostgreSQL root user password.

$ sudo su postgres
$ psql


postgres=#  ALTER USER postgres WITH PASSWORD 'Passw0rd';
postgres=# \q


Step 5:
-------
We need to set the access permission  as trust to root user. The default access is md5. Open pg_hba.conf file

$ sudo subl /etc/postgresql/9.1/main/pg_hba.conf

Make sure the following commands

# Database administrative login by Unix domain socket
local   all             postgres                                trust

Step 6:
------
We must restart the postgresql

$ sudo service postgresql restart

No comments:

Post a Comment