Re: Problem w/ dumping huge table and no disk space - Mailing list pgsql-general

From David Ford
Subject Re: Problem w/ dumping huge table and no disk space
Date
Msg-id 3B998422.4090008@blue-labs.org
Whole thread Raw
In response to Problem w/ dumping huge table and no disk space  (David Ford <david@blue-labs.org>)
List pgsql-general
I think I've been successful here :)

I ran pg_dump from the new machine and it doesn't suffer the memory
blowup the old one does.  I gleaned 1.7G of data from it, doing inserts now.

_Thank you_ to everyone for their suggestions, this data is really
important.  I should have tried the new pg_dump in the first place.

David

Tom Lane wrote:

>David Ford <david@blue-labs.org> writes:
>
>>I had b5 on another machine and it didn't want to upgrade cleanly, thus
>>my attempt to dump/restore.
>>
>
>Now that I think about it, I believe you need to run the
>contrib/pg_resetxlog utility to update from 7.1beta5 to final.  If you
>do that (read its README first!) you should be able to do the update.
>
>            regards, tom lane
>



pgsql-general by date:

Previous
From:
Date:
Subject: Re: What Is The Firing Order?
Next
From: Tom Lane
Date:
Subject: Re: recursive text construction in plpgsql?