install psql on ubuntu 16.04
Postgres installation on ubunut 16.04 if youre using the root user apt-get update update the ubuntu repository apt-get upgrade upgrade the package to the latest version its updating the packages now Once its update and the packages will upgrade now sudo apt-get upgrade now going to download the postgres 9.5 in ubunutu type the below command apt-get install postgresql postgresql-contrib Once it will done ,This will showing the configuration file file path and data path also in terminal now we are going to login to the postgres9.5 for login with postgres need to use this command su postgres (via this user only we able to access the database ) Type with psql and enter it will allow to login to psql terminal need to change the password for connect from the client tool like (Pg Admin) for change the password for postgres #\password postgres now we need to change the configuration settings in configuration files in postgresql . ...