Postgres Pro
Downloads
Home   >   mailing lists

Re: Relation 'pg_largeobject' does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: Relation 'pg_largeobject' does not exist
Date
Msg-id 11900.1142300301@sss.pgh.pa.us
Whole thread Raw
In response to Relation 'pg_largeobject' does not exist  (Brandon Keepers <bkeepers@gmail.com>)
Responses Re: Relation 'pg_largeobject' does not exist  (Brandon Keepers <bkeepers@gmail.com>)
List pgsql-general
Tree view 
Brandon Keepers <bkeepers@gmail.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

pgsql-general by date:

Previous
From: Casey Duncan
Date:
Subject: Re: Possible infinite loop in query using bitmap scans
Next
From: Brandon Keepers
Date:
Subject: Re: Relation 'pg_largeobject' does not exist