Postgres remote connection

Question

I'm having trouble getting postgres to allow remote access over the LAN. The 2 conf files are as follows...

#postrges.conf

# - Connection Settings - .200 is where the server's IP
listen_addresses = '192.168.0.200,localhost'
port = 5432
...

#pg_hba.conf
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# allow LAN connections only...
host    all             all             192.168.0.0/255         md5

Whats wrong here? The postgres server won't even restart...

Answer 1

 # allow LAN connections only...
 host    all             all             192.168.0.0/255         md5

try to change that into CIDR notation

 # allow LAN connections only...
 host    all             all             192.168.0.0/32         md5

try to change

listen_addresses = '192.168.0.200,localhost'

into

listen_addresses = '*'

About the not restarting: check your postgres logfile or on liux: /var/log/syslog

If the postgres server is restarting, check if its running on the needed interfaces using

  netstat -tapn