Pages

Friday, September 24, 2010

Postgres - Server doesn't listen

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