Re: Database just hangs at startup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Terry Khatri <terrykhatri531(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database just hangs at startup
Date: 2012-10-16 22:12:10
Message-ID: 4063.1350425530@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Terry Khatri <terrykhatri531(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2012-10-16 22:18:29 Re: Database just hangs at startup
Previous Message Bruce Momjian 2012-10-16 18:30:45 Re: thread-safety flag on Solaris 10