I
I
Ivan Balan2014-03-08 15:55:50
PostgreSQL
Ivan Balan, 2014-03-08 15:55:50

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

1 answer(s)
P
Puma Thailand, 2014-03-08
@Toddams

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 question

Ask a Question

731 491 924 answers to any question