Re: Relation 'pg_largeobject' does not exist

From: Brandon Keepers <bkeepers(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Relation 'pg_largeobject' does not exist
Date: 2006-03-14 01:43:49
Message-ID: 1142300629.10492.9.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-14 02:12:55 Re: Relation 'pg_largeobject' does not exist
Previous Message Tom Lane 2006-03-14 01:38:21 Re: Relation 'pg_largeobject' does not exist