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

15 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.

Puneet kumar 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

Ashish Kumar 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

Shivam shakya 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.

SONAM THAKUR 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

Priya Rathour 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.