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 than
Hi Steve,
On Tue, Dec 10, 2013 at 11:08 AM, Steve Erickson
serick...@digitiliti.comwrote:
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
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