Re: [GENERAL] [pgadmin-support] Lost database

2013-12-10 Thread Albe Laurenz
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

Re: [GENERAL] [pgadmin-support] Lost database

2013-12-09 Thread John R Pierce
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