John R Pierce wrote:
> if the postgresql server was running when that file backup was made(*),
> its pretty much worthless, it will have data corruption and errors
> throughout.
Well, it would be better than nothing.
You can pg_resetxlog and manually clean up the inconsistencies.
That's better tha
On 12/9/2013 10:17 PM, Dinesh Kumar wrote:
If we’re unsuccessful, we do have a filesystem backup from several
months ago that we can apply and then go through the tedium of trying
to fill in the missing blanks for those months. Since there are so
many rows, is there a tool or procedure we ca
Hi Steve,
On Tue, Dec 10, 2013 at 11:08 AM, Steve Erickson
wrote:
> While prepping a second server today the /var/lib/postgres/ directory
> got deleted. Yes, everything. We’re running on Ubuntu 10.4 and Postgres
> 8.4. We immediately shutdown everything but now need to recover the
> directory
