Re: Relation 'pg_largeobject' does not exist

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

Brandon Keepers <bkeepers(at)gmail(dot)com> writes:
> I'm trying to upgrade a postgresql 7.0.3 database that uses large
> objects to a more recent version, but I'm not able to export the blobs.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Keepers 2006-03-14 01:43:49 Re: Relation 'pg_largeobject' does not exist
Previous Message Casey Duncan 2006-03-14 01:25:49 Re: Possible infinite loop in query using bitmap scans