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 .
With out changes we able to connect the psql from local host only but we have the pg admin in some another system in same network
for editing configuration files I am using the filezilla client
my linux ip address is – 192.168.2.6
connect the psql server via filezilla and goto the following path
/etc/postgresql/9.5/main/pg_hba_conf
Find the below line and add the following line the conf file
here my network is range is 192.168.2.1 to 192.168.2.255 so I will added below if have the two network means you may given to network ip ,for example if youre connected through vpn means the ip will assign 192.168.3.1 series you have to enter the

192.168.3.1/24 in the configuration file





Find the following line and edit below





In the same path postgresql.conf file is there click on edit and find the





listen_address = 'localhost' and change as a listen_address='*'




need to remove the #  before the line









now we need to restart the postgres9.5




now we able to connect from the pgadmin



click on the save

now we able to run the query





Please refer the following youtube link for install psql on ubuntu 16.04 


Comments

Post a Comment

Popular posts from this blog

Enable the SSL in jetty web server

Image
Enable the SSL in jetty web server Operating system : Ubuntu 16.04.03 Jetty server :9.4.7 First enter the following command java -jar start.jar –-add-to-startd=ssl This command will make a directory in the jetty called start.d and also copy the file ssl.ini ,Copy the keystore from the modules/ssl/keystore to etc/ssl We need to add the two lines in the ssl.ini /opt/Jetty_Ssl/start.d Add this two lines end of the document --module=ssl --module=https Find my ssl.ini file below Goto modifying the editing on the start.ini We need to enter the following line in start.ini in end of the document jetty.ssl.port=8443 Find my start.ini file below # --------------------------------------- # Module: ssl # Enables a TLS(SSL) Connector on the server. # This may be used for HTTPS and/or HTTP2 by enabling # the associated support modules. # --------------------------------------- --module=ssl ### TLS(SSL) Connector Configuration ## Connector hos...
Read more

How to install Edubuntu in Windows through oracle VM

Image
How to install EdUbuntu in oracle virtual box My system ======== Host machine : windows 10 Virtual software : Oracle virtual box Processor           : core i5 RAM                 : 8GB   For download the edubutu goto this site https://www.edubuntu.org/download Once you get the iso image file Click on the new button After getting the create virtual machine console fill the following details Now click on the create button Now provide the hard disk space  and click on the create button Once its created goto setting on the top Need to choose the image from the Storage option and click on the empty   below the controller:IDE ,Then click on the choose virtual optical disk file Browse the image file and select Edubuntu iso file Now click on the open and once its selected the properly the empty...
Read more

How to configure the apache2 in the ubuntu 16.04 Step by Step

Image
How to configure the apache2 in the ubuntu 16.04 Step by Step Refer the video for configure apache2 in youtube For installing the apache2 configuration first we need to update the apt get repository now we need to install the apche2 with the following command         #apt-get install apache2 Give the following command to start the apache2     #service apache2 star     t for checking the service status     #service apche2 status Now we going to allow the apche2 service through firewall for that we need to check the firewall status this will shows which are the ports allowed by the firewall now we enable the apche2 with following command           #ufw app list   this command will show the which are the service available in the ubuntu16.04 here showing following the apache apache – only 80 por...
Read more