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 <mattxbart@gmail.com> wrote:
> 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 missing the pg_xlog directory files? I find it odd
> that the pg_resetxlog command is just missing... I have postgres
> installed from source on my laptop and it is there.
>
> Thanks,
> Matt
>