Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TOFN5-0006uT-E6
	for pgsql-admin@postgresql.org; Tue, 16 Oct 2012 22:12:19 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TOFMz-0006rl-He
	for pgsql-admin@postgresql.org; Tue, 16 Oct 2012 22:12:19 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q9GMCAbt004064;
	Tue, 16 Oct 2012 18:12:11 -0400 (EDT)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Terry Khatri <terrykhatri531@gmail.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Database just hangs at startup
In-reply-to: 
 <CANH4f+jfuO+oJFf0P7JkK5BORXO701xtT9yYoGf8Fs8GV5Jgkw@mail.gmail.com>
References: 
 <CANH4f+jfuO+oJFf0P7JkK5BORXO701xtT9yYoGf8Fs8GV5Jgkw@mail.gmail.com>
Comments: In-reply-to Terry Khatri <terrykhatri531@gmail.com>
	message dated "Tue, 16 Oct 2012 02:49:45 +0500"
Date: Tue, 16 Oct 2012 18:12:10 -0400
Message-ID: <4063.1350425530@sss.pgh.pa.us>
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201210/53
X-Sequence-Number: 40169

Terry Khatri <terrykhatri531@gmail.com> writes:
> I am having problems making any connection to the database, it was working
> fine and problems started when I added a wrong cidr in pg_hba.conf to allow
> connection from other hosts in the network,  I took out that entry and
> restarted it but it just does not work it starts up fine but all
> connections just hang forever, whether I try it with psql or pgadmin III.

> listen_address='^'

Well, that setting is certainly wrong.  Perhaps you meant
listen_address='*'

			regards, tom lane