After installing postgres-8.3 database server,
I started the postgres server by using the command ,
/etc/init.d/postgres start
The server was started
When I connected to the Server from other system through LAN,
I got the following error
I checked the configuration properties , which is in the location ,
/etc/postgresql/8.3/main/postgresql.conf
When I checked the Connection Settings Section ,
if found that,
# listen_address='*'
to be in commented section.
I removed it and the configuration file looked like this ,
Remember, when ever you modify the configuration files of postgres,
We need to restart , to make the new configuration to take effect.
I restarted the postgres server by,
/etc/init.d/postgres-8.3 stop
/etc/init.d/postgres-8.3 start
or
/etc/init.d/postgres-8.3 restart


No comments:
Post a Comment