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 > > D

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

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 runn

[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

Re: [GENERAL] pg_resetxlog command not found

2007-06-18 Thread Matt Bartolome
After poking around some more the command is located in /usr/lib/postgresql/8.1/bin/pg_resetxlog on ubuntu. On 6/18/07, Matt Bartolome <[EMAIL PROTECTED]> wrote: I am doing some experimentation with a WAL archiving HA setup. I tried turning to the pg_resetxlog command after removin

[GENERAL] pg_resetxlog command not found

2007-06-18 Thread Matt Bartolome
I am doing some experimentation with a WAL archiving HA setup. I tried turning to the pg_resetxlog command after removing some corrupted files and it is not installed using the ubuntu dapper 8.1 package. How do I get this command installed, or is there some other way to repair a database that is