Lists: | pgsql-admin |
---|
From: | Scott Whitney <swhitney(at)journyx(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:18:29 |
Message-ID: | 9i574rembki171mg1gegu9qg.1350425909799@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
From: | vipul shah <vipmshah(at)gmail(dot)com> |
---|---|
To: | Scott Whitney <swhitney(at)journyx(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Terry Khatri <terrykhatri531(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database just hangs at startup |
Date: | 2012-10-17 13:52:19 |
Message-ID: | CALXQATY1mbOh7kv0fE-ffV-3gBKyYKUeh2zNJPV611hk1UbV2A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Terry,
It looks like typo in local line in pg_hba.conf. I work in pg8.4 and 9.1
but I think that there is nothing like 'trustit' in pg_hba.conf file in 9.2.
*local all all trustit
*Change this to
*local all all trust
*
Regards,
Vipul Shah
On Tue, Oct 16, 2012 at 5:18 PM, Scott Whitney <swhitney(at)journyx(dot)com> wrote:
> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>