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

11 comments:

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

Anonymous 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

Anonymous said...


Wow! This blog is high-ranking. So to do the website you need a perfect hosting solution. you can visit France Dedicated Server Hosting From Onlive Server

Divyanshu Rajput said...

Really this blog is Influential. I have never seen this type of blog post. This is very helpful for me. Keep it up. If you want to make better your online business choose Dubai Dedicated Server Hosting

Anjali Mathur said...

Very nice blog, mind-blowing information in this blog. Also, I share such important information about Dedicated Hosting. also, Cheap Dedicated Server Services is very well and at a very affordable price. Indial Dedicated Server Hosting

Rohan kashyap said...


Such an informative blog and an excellent way to talk about it, thanks for this blog. But I can help you to grow your website by Italy Dedicated Serverand you know how this could be important for this modern world. Thanks once again.

Anonymous said...

Hello author I am very happy to read this post, it's a very interesting blog, and so informative. If you don't want to interrupt your website surfing then get the best Switzerland Dedicated Server

Anonymous said...

Your blog includes technical information which is so helpful for us. Your writing skill is really appreciable. If you want to host multiple types of websites without any issue, you can pick France Dedicated Server plans from Onlive Server. We provide you complete server security.

Pavan Rajput said...

Thanks for your reach-out efforts. This is a great blog. Keep sharing.
I will try this. Web Hosting plays a very important role in the business world. And it is important to have the best hosting services. Buy the best Germany Dedicated Server Hosting
service for your website.