Friday, October 25, 2013

How to install and remove Postgresql in ubuntu 12.04

PostgreSQL:

1) To Install postgresql run this command in terminal

sudo apt-get install postgresql

2) if you facing any error, make sure you already install libpq-dev. The libpq-dev package is 
for compiling wrappers/clients against libpq.
sudo apt-get install postgresql-9.1 libpq-dev

3) Now check it out installation is successful or not
locate postgresql

4) Check the installed version.
psql -V

5) Now let’s take look to postgres console
su postgres

You can install UI for this command:
sudo apt-get install pgadmin3
 Remove PostgreSQL from Ubuntu

* To Remove the Postgresql Completely the command is

1.) sudo apt-get remove postgresql-"version number"

2.) dpkg -l | grep postgresql 

0 comments:

Post a Comment