Re: Unable to dump database using pg_dump

Let me ask this question. Is there any other option for moving data
from one server to another that doesn't involve pg_dump? If I can get
the data out of this server, and onto my new one I don't care if the old
server gets fixed. I just need the data. The new server already has
the table structure, I just need the most current data to put into the
server.

Tom Lane wrote:
> Adam Dear <adear(at)usnx(dot)net> writes:
>> If I restored the data directory again wouldn't that undo the Vacuum
>> Freeze command that I did that has locked the database into the state
>> that it is in now?
>
> It'd undo the freeze, but that doesn't get you any closer to a solution.
> What you need is to get rid of the wrapped-around xmax in the (0,1)
> tuple.
>
> regards, tom lane
>