Re: [GENERAL] postgres startup failure

2010-05-21 Thread Tom Lane
Matt Bartolome writes: > On Thu, May 20, 2010 at 3:36 PM, Tom Lane wrote: >> So right now I'm wondering whether you're not failing to notice >> a relevant log message(s). You've evidently managed to launch >> the syslogger --- where is it configured to write the postmaster >> log? > Gosh, you k

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
On Thu, May 20, 2010 at 3:36 PM, Tom Lane wrote: > Matt Bartolome writes: > > Setting the breakpoint (b exit) got me a little farther... > > > DEBUG: invoking IpcMemoryCreate(size=32595968) > > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > > Detaching after fork from child

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome writes: > Setting the breakpoint (b exit) got me a little farther... > DEBUG: invoking IpcMemoryCreate(size=32595968) > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > Detaching after fork from child process 19066. > Detaching after fork from child process 19067

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
On Thu, May 20, 2010 at 2:44 PM, Tom Lane wrote: > Matt Bartolome writes: > > gdb output... > > > DEBUG: - > > DEBUG: invoking IpcMemoryCreate(size=32595968) > > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > > Detaching after fork fr

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome writes: > 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 proces

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
Hi Tom, On Thu, May 20, 2010 at 11:33 AM, Tom Lane wrote: > Matt Bartolome 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 o

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome 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? > DEBUG: invoking IpcMemoryCreate(size=32595968) > DEBUG: max_safe_fds = 984, usable_fds = 1000, already_open = 6

[GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
Hi, 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. The backup on the primary is done nightly using the following commands: # psql -d operations -U postgres -c "SELECT pg_start_backup('/data/postgres')"; # tar