Solution for “Server Not Listening” Error in Postgres Server

In this blog the following topic will be covered

How to resolve “server not listening error” in Postgres server while connecting from another host

Prerequisites: PostgreSQL-9.3.4-1

Install Postgres in the local machine. If other hosts want to connect to the local Postgres Server. While we connecting to the local Postgres from another host within a network will get the following message “server not listening “

We should change as follows :

1. Open the file in the directory

C:\Program Files (x86)\PostgreSQL\9.3\data\postgresql.conf
In this file postgresql.conf
replace listen_addresses = ‘*’ ( with star symbol)

2. Open the file in the directory

C:\Program Files (x86)\PostgreSQL\9.3\data\pg_hba.conf
In this file pg_hba.conf
Include the following code segment at the end of the file :
host all all 0.0.0.0/0 md5
host all all ::/0 md5

Save those modified files and restart the server.Now the problem will be solved.


Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework


Free
Download

In case if you have any query please get us at helical@helicaltech.com
Thank You
BI Developer
Anjaneyulu
Helical IT Solutions Pvt Ltd

database local server postgres postgres connection postgres server postgresSQL SQL