Re: Relation 0 does not exist

Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
>> (Now postmaster won't shutdown pg_ctl: postmaster does not shut down)

> It's stuck in ServerLoop () at postmaster.c:949
> (gdb) print rmask
> $1 = {fds_bits = {8, 0, 0, 0, 0, 0, 0, 0}}
> (gdb) print wmask
> $2 = {fds_bits = {0, 0, 0, 0, 0, 0, 0, 0}}
> (gdb) print timeout
> $3 = {tv_sec = 60, tv_usec = 0}

That's about what I'd expect it to be doing. The final decision to exit
would normally be made when we see the shutdown process exit (about
line 1587 in postmaster.c). What are the contents of ShutdownPID,
CheckPointPID, Shutdown, and FatalError? Are there any remaining child
processes of the postmaster?

> Remembers Tip 1: Don't kill -9 the postmaster... Hmm 2 and 15 don't do anything..

That tip is pretty obsolete, but before you pull the trigger it would be
nice to try to learn more. I wonder if you have hit some obscure race
condition that prevents the postmaster from realizing it's done?

regards, tom lane