1.07.2015

Remote access postgresql from external client (9.3)

1. Edit pg_hba.conf

vi /etc/postgresql/9.3/main/pg_hba.conf
add
host all all [CLIENT_IP]/24 trust

2. Edit postgresql.conf

vi /etc/postgresql/9.3/main/postgresql.conf
Find 'listen_addresses' and change to
listen_addresses = ‘*’

3. Restart postgresql


sudo service postgresql restart

8 comments:

Shivani Bisht said...

Thank you for sharing your article. Great efforts put it to find the list of articles which is very useful to know Visit UK VPS Hosting

mamta said...

Nicely you explained everything in your article. Thanks for your information; this is nice and helpful… Definitely going to share this article to my friends.
Brazil VPS Hosting

Priyanka Singh said...

I am speechless this is really Mindblowing, This is an amazing superb article Keep Sharing this...
Thanks thanks a lotttttttt!!!!

USA VPS Hosting

Social Graphic said...

we are solute this information!!! I have got in very important information in this article posting. Thanks for sharing your great information keep it up!!!!!!
Germany VPS Hosting

Arun Kumar said...

This is mind-blowing information. I love this post. is this an amazing technical services solution and managed?
Japan VPS Hosting

Shivani Bisht said...

Great Article… I love to read your articles because your writing style is too good, it is very helpful for all of us and I never get bored while reading your article. Visit Germany VPS Hosting

mamta said...

This is very informative blog, writing skill is very creative. Thanks for sharing this kinda articles.
South Korea VPS Hosting

Onlive Server said...

As you are providing information that is extremely good for everyone. Basically, we want to say that your knowledge really impressive that should be spread all over the world. Basically, We are leading server hosting Company. There are lots of companies available in the market that provides the hosting solution. if you want any other information about server hosting Contact us without any hesitation. Onlive Server, here are available multiple types of server hosting solutions. for more information Click here - USA VPS Hosting.