Re: Problem w/ dumping huge table and no disk space

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(at)blue-labs(dot)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
>