Tom,
On Mon, 2006-03-13 at 20:38 -0500, Tom Lane wrote:
> pg_dump should work. If using a pg_dump version older than 8.1, you
> need to use -b switch and a non-default output format (I'd suggest -Fc).
>
> regards, tom lane
Thanks for your quick response! I had actually just been trying that
(with 7.1) and came across another error:
NOTICE: ShmemAlloc: out of memory
NOTICE: LockAcquire: xid table corrupted
dumpBlobs(): Could not open large object. Explanation from backend:
'ERROR: LockRelation: LockAcquire failed
'.
Any ideas what would be causing that? I'm going to try compiling a
newer version and running it again.
Thanks,
Brandon
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
