Re: postgres startup failure

Hi Tom,

On Thu, May 20, 2010 at 11:33 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Matt Bartolome <mattxbart(at)gmail(dot)com> writes:
> > I'm attempting to start postgres on a standby machine from a backup. Both
> > the primary and standby are running postgres 8.4, fedora 12.
>
> 8.4.what exactly?
>

I'm running 8.4.2 on the primary and 8.4.4 on the standby via yum. I
wouldn't think a minor release change would cause what I'm seeing... I've
also built 8.4.2 from source on the standby and I get the same debug output.
I should also mention these are both VM's (vmware) and are running under a
windows host OS.

> DEBUG: invoking IpcMemoryCreate(size=32595968)
> > DEBUG: max_safe_fds = 984, usable_fds = 1000, already_open = 6
> > DEBUG: logger shutting down
> > DEBUG: shmem_exit(0): 0 callbacks to make
> > DEBUG: proc_exit(0): 0 callbacks to make
> > DEBUG: exit(0)
> > DEBUG: shmem_exit(-1): 0 callbacks to make
> > DEBUG: proc_exit(-1): 0 callbacks to make
>
> Hmm. I'm thinking that the postmaster must have simply crashed at some
> time between starting the logger subprocess and starting the startup
> subprocess. You could try running the postmaster under gdb to see
> if you can get a stack trace, along the lines of
>
> $ gdb /usr/bin/postgres
> gdb> run -d 3 -D /data/postgres/
> ... crash
> gdb> bt
> ... printout
> gdb> quit
>
>
gdb output...

DEBUG: -----------------------------------------
DEBUG: invoking IpcMemoryCreate(size=32595968)
DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10
Detaching after fork from child process 18310.
Detaching after fork from child process 18311.

Program exited with code 01.
DEBUG: logger shutting down
DEBUG: shmem_exit(0): 0 callbacks to make
DEBUG: proc_exit(0): 0 callbacks to make
DEBUG: exit(0)
DEBUG: shmem_exit(-1): 0 callbacks to make
DEBUG: proc_exit(-1): 0 callbacks to make
(gdb) bt
No stack.

You might need to "continue" if it decides to stop at the point of
> forking off the logger.
>
> regards, tom lane
>

Do you have any other suggestions?

Thank you,
Matt