> The pg_dump backup is a better bet.
>
> If you are really desperate to recover the latest changes, try
> pg_resetxlog then pg_dump, and diff the dump file against your good
> pg_dump to see which changes you want to believe and apply. But I'd
> still say you want to initdb and restore from the pg_dump backup before
> going forward.
Thanks for all of the advice. Fortunately, this is a lesson I am learning on my practice server.
I would hate to think of the predicament I would be in if this happened to my server at work.
Here, none of the data is critical, I just didn't want to re-created all of the schemas that I am
loading test data to.
But lesson learned, I am going to a closer look at my back-up strategy.
Regards,
Richard Broersma Jr.
