pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase just hangs at startup
4+ messages / 4 participants
[nested] [flat]
* Database just hangs at startup
@ 2012-10-15 21:49 Terry Khatri <terrykhatri531@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Terry Khatri @ 2012-10-15 21:49 UTC (permalink / raw)
To: pgsql-admin
Hi,
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.
Here are the contents of pg_hba.conf
============================
*# TYPE DATABASE USER ADDRESS METHOD*
* *
*local all all trustit*
*# IPv4 local connections:*
* *
*host all all 127.0.0.1/32 md5*
* *
*host all all 192.168.56.0/24 trust*
* *
*# IPv6 local connections:*
* *
*host all all ::1/128 trust*
* *
*# Allow replication connections from localhost, by a user with the*
* *
*# replication privilege.*
* *
*#local replication sns84 trust*
* *
*host replication sns84 127.0.0.1/32 trust*
* *
*host replication sns84 0.0.0.0/0 trust*
* *
*host replication sns84 ::1/128 trust*
*----*
**
*
Here are the logs
===============
,LOG: database system was interrupted; last known up at 2012-10-16 01:45:00
UZT
,LOG: database system was not properly shut down; automatic recovery in
progress
,LOG: record with zero length at 0/1B95BF48
,LOG: redo is not required
,LOG: autovacuum launcher started
,LOG: database system is ready to accept connections
,WARNING: pgstat wait timeout
,WARNING: pgstat wait timeout
,WARNING: pgstat wait timeout
,WARNING: pgstat wait timeout
,WARNING: pgstat wait timeout
,WARNING: pgstat wait timeout
---
listen_address='^'
Please help me fix it, I am using version 9.2
Thanks
T
*
**
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database just hangs at startup
@ 2012-10-16 22:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Terry Khatri <terrykhatri531@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2012-10-16 22:12 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database just hangs at startup
@ 2012-10-16 22:18 Scott Whitney <swhitney@journyx.com>
0 siblings, 1 reply; 4+ messages in thread
From: Scott Whitney @ 2012-10-16 22:18 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Terry Khatri <terrykhatri531@gmail.com>; +Cc: 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@sss.pgh.pa.us> wrote: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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Database just hangs at startup
@ 2012-10-17 13:52 vipul shah <vipmshah@gmail.com>
parent: Scott Whitney <swhitney@journyx.com>
0 siblings, 0 replies; 4+ messages in thread
From: vipul shah @ 2012-10-17 13:52 UTC (permalink / raw)
To: Scott Whitney <swhitney@journyx.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Terry Khatri <terrykhatri531@gmail.com>; 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@journyx.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@sss.pgh.pa.us> wrote:
> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-10-17 13:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-15 21:49 Database just hangs at startup Terry Khatri <terrykhatri531@gmail.com>
2012-10-16 22:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-10-16 22:18 Re: Database just hangs at startup Scott Whitney <swhitney@journyx.com>
2012-10-17 13:52 ` vipul shah <vipmshah@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox