On Monday 01 March 2010 @ 15:41, Ed Loehr (LoehrTech.com) wrote: > "Ed L." <pgsql@xxxxxxxxxxxxx> 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)? This just happened again ~24 hours after full reload from backup. Arrrgh. Backtrace looks the same again, same file, same __read_nocancel(). $PGDATA/global/pg_auth looks fine to me, permissions are 600, entries are 3 or more double-quoted items per line each separated by a space, items 3 and beyond being groups. Any clues? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
