Nowadays most applications use PostgreSQL as their database than Mysql. PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. Therefore if you are planning to have a career in Software Engineering knowledge of PostgreSQL comes in handy. So today lets discuss Install Postgres Ubuntu. Reason for this post is there are few thing beginners should know when he starts using Postgres.
The easiest way to install Postgres in Ubuntu is run below command.
sudo apt install postgresql
This will install the latest PostgreSQL version which is currently postgresql-10.
But sometimes you might need an older version which compatible with your application.
For such an event you can use below procedure to achieve that.
For the tutorial, let’s install postgresql-9.6 for that run below commands in terminal.
sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -sc)-pgdg main" wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update sudo apt-get install postgresql-9.6
Now you have installed Postgres in Ubuntu and you can confirm the version using below command.
If you can see a version number you installed, then Postgres successfully installed.
Now, let’s start Postgres using below command.
sudo service postgresql start
Now your server should be running. You can check that using below command.
sudo service postgresql status
Now how to access the psql terminal?
When Postgres is being installed, it creates a user called postgres.
This user is created as Ubuntu System user not in Postgres as Mysql would do. You can see it using the below command.
In end of file you can see a line starts with postgres. The x after postgres means there is no password setted for it. Reason for bring this user matter is You need to log into psql using that user. this user is not activated and you should not activate is using passwd command. Otherwise it will leave security vulnerbility if you used weak password like postgres Let's see how to use psql without activating postgres user. Type below command to become postgres user without password. (For this you need root privilages)
sudo -i -u postgres
now type psql to enter Postgres terminal. After that type below command to change default user password.
Please remember that password. because it is needed when you are going to connect the Postgres through your application. If you want to exit terminal, then type \q and enter. Now you are in terminal as postgres user. use exit to log out. If you want to access psql terminal use below commad.
sudo -u postgres psql
If you don't want to use psql terminal you can use GUI client call pgamin (https://www.pgadmin.org/download/) Now you you know basics of Install Postgres Ubuntu and get development start up :D