--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Harry <[EMAIL PROTECTED]> writes:
> > In hindsight I would have done some things differently, like
> posting to
> > one of the lists. If you think that it would be better for people
> to
> > ask the list and run from there then I will leave it.
>
> Well, w
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Sun, Dec 19, 2004 at 04:11:17PM -0800, Harry wrote:
>> http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html
> Huh, this sounds like transaction Id wraparound to me.
Given the mention of a drive glitch, I'm mentally comparing it to our
Harry <[EMAIL PROTECTED]> writes:
> In hindsight I would have done some things differently, like posting to
> one of the lists. If you think that it would be better for people to
> ask the list and run from there then I will leave it.
Well, we should certainly encourage people to post such problem
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Harry <[EMAIL PROTECTED]> writes:
> > Is there any material online on how to recover a corrupt postgresql
> > database?
>
> There are dozens if not hundreds of case histories in the mailing
> list archives; the latest example is this thread:
> http://archi
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html
>
> Huh, this sounds like transaction Id wraparound to me. Do you
> regularly run vacuums on the whole database? Did you ask for expert
> help on the lists before running to do w
Harry <[EMAIL PROTECTED]> writes:
> Is there any material online on how to recover a corrupt postgresql
> database?
There are dozens if not hundreds of case histories in the mailing list
archives; the latest example is this thread:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00479.php
On Sun, Dec 19, 2004 at 04:11:17PM -0800, Harry wrote:
> I have just had a bit of a disaster with a database and found very
> little material online about how to recover from a corrupted database.
> This is not the first time I have had to recoover data from a postgres
> database which was caused e
I have just had a bit of a disaster with a database and found very
little material online about how to recover from a corrupted database.
This is not the first time I have had to recoover data from a postgres
database which was caused either by some hardware failure or my own
error (not sure which
