Hi,
I compiled a Postgres 8.0.3 on a SuSE 9.3 system.
This sytem has several network-interfaces. One points to the wild internet.
Now I'd like postgres only to listen for localhost, the LAN and probaply
the socket.
I wrote listen_addresses = 'localhost,192.168.100.1' in the
postgresql.conf restartet the pg-server and looked with netstat -lan
|grep 5432.
It still showed
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
tcp 0 0 :::5432 :::* LISTEN
unix 2 [ ACC ] STREAM LISTEN 65292 /tmp/.s.PGSQL.5432
Uncommenting the listen_addresses = 'localhost' in the default conf-file
does the same.
Nothing, that is. :(
I though that perhaps PG reads some other file but as I changed the port
to 5433 in the next parameter below the listen_addresses it worked.
Where am I wrong ?
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings