Also, I don't know if this applies to windows systems, but on linux systems you have to also modify postgresql.conf On my system, it is in the same directory as pg_hba.conf looks like this: #------------------------------------------------------------------------------ # CONNECTIONS AND AUTHENTICATION #------------------------------------------------------------------------------ # - Connection Settings - listen_addresses = '192.168.1.101' # what IP address(es) to listen on; The address here is mine, it is set to localhost or 127.0.0.1 by default On Sunday 05 April 2009 15:27:14 Johan Nel wrote: > Jennifer, > > Jennifer Trey wrote: > > Hi, I am trying to create my DB schema on the server through my > > development laptop. > > > > I have installed Web Server 2008 and PostgreSQL. They are both running. > > For some reason its not working. Do I need to open some firewall ports? > > PostgreSQL runs on 5432. ( I think I did that though). Do I need to > > configure PG somehow as well? > > Default PG installation is setup to work only on localhost or 127.0.0.1 > > You need to edit your pg_hba.conf file too. Look for the lines: > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > > Add a line below that depending the IP address range that you want to > connect from, similar to: > host all all 10.0.0.1/8 md5 > > Remember to reload your configuration. > > HTH, > > Johan Nel > Pretoria, South Africa. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
