Re: Database just hangs at startup

I'd hate to contradict Tom, and since ^ is probably a typo, and you likely meant *, yes, that's likely, but be sure you understand the implications of listening on all interfaces first. Just saying from an IT point of view.Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: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