Answer the question
In order to leave comments, you need to log in
How to share postgresql over local network?
Hello, there was a problem with Postgresql sharing over the local network. Judging by the manuals on the net, I did the following:
1. Changed the line in the postgresql.conf file listen_addresses = *
2. Added a line with the following parameters in the pg_hba.conf
file:
Type: host
Database: all
User: postgres
Ip-Addresses: 192.168.0.100/ 145
Method: md5
And I restart the service. Windows axis, if anything. But the server does not want to restart. It just tries to connect and the server does not turn on. If you delete the last line from the pg_hba.conf file , the server is turned on again.
I do everything in pgAdminIII
Answer the question
In order to leave comments, you need to log in
You have a subnet mask through a fraction, not a range.
That is, this is nonsense 100/145
if you want to allow for the entire subnet, then you need
192.168.0.0/24
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question