Skip site navigation (1) Skip section navigation (2)

Re: Hung postmaster (8.3.9)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hung postmaster (8.3.9)
Date: 2010-02-28 15:58:13
Message-ID: 8705.1267372693@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> (gdb) bt
> #0  0x000000346f8c43a0 in __read_nocancel () from /lib64/libc.so.6
> #1  0x000000346f86c747 in _IO_new_file_underflow () from /lib64/libc.so.6
> #2  0x000000346f86d10e in _IO_default_uflow_internal () from /lib64/libc.so.6
> #3  0x000000346f8689cb in getc () from /lib64/libc.so.6
> #4  0x0000000000531ee8 in next_token (fp=0x5b90f20, buf=0x7fff59bef330 "", bufsz=4096) at hba.c:128
> #5  0x0000000000532233 in tokenize_file (filename=0x5b8f3f0 "global", file=0x5b90f20, lines=0x7fff59bef5c8, 
>     line_nums=0x7fff59bef5c0) at hba.c:232
> #6  0x00000000005322e9 in tokenize_file (filename=0x5b8f3d0 "global/pg_auth", file=0x5b90ce0, lines=0x98b168, line_nums=0x98b170)
>     at hba.c:358
> #7  0x00000000005327ff in load_role () at hba.c:959
> #8  0x000000000057f300 in reaper (postgres_signal_arg=<value optimized out>) at postmaster.c:2145
> #9  <signal handler called>
> #10 0x000000346f8cb323 in __select_nocancel () from /lib64/libc.so.6
> #11 0x000000000057cc33 in ServerLoop () at postmaster.c:1236
> #12 0x000000000057dfdf in PostmasterMain (argc=6, argv=0x5b73fe0) at postmaster.c:1031
> #13 0x00000000005373de in main (argc=6, argv=<value optimized out>) at main.c:188

The postmaster seems to be stuck trying to read $PGDATA/global/pg_auth
(which would be an expected thing for it to do at this point in the
startup sequence).  Does that file exist?  Is it an ordinary file?
Do its contents look sane (a list of your userids and their passwords
and group memberships)?

			regards, tom lane

In response to

pgsql-general by date

Next:From: John GageDate: 2010-02-28 16:42:57
Subject: Absent output from psql
Previous:From: Bruce MomjianDate: 2010-02-28 15:13:56
Subject: Re: [GENERAL] trouble with to_char('L')

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group