Re: vacuumlo fails pgsql ver 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuumlo fails pgsql ver 8.3
Date
Msg-id 17265.1328463595@sss.pgh.pa.us
Whole thread Raw
In response to vacuumlo fails pgsql ver 8.3  (Pat Heuvel <pheuvel@tpg.com.au>)
Responses Re: vacuumlo fails pgsql ver 8.3  (Pat Heuvel <pheuvel@tpg.com.au>)
List pgsql-general
Pat Heuvel <pheuvel@tpg.com.au> writes:
> [ vacuumlo fails ]
> When I added the -v option, there were many "removing lo xxxxx" messages
> before the above messages appeared. I have previously tried to reindex
> pg_largeobject, but that process failed as well.

You need to get the index consistent before trying vacuumlo; that
program is not designed to deal with inconsistent catalogs.

What exactly happens when you try to reindex pg_largeobject?

            regards, tom lane

pgsql-general by date:

Previous
From: Pat Heuvel
Date:
Subject: vacuumlo fails pgsql ver 8.3
Next
From: Giuseppe Sacco
Date:
Subject: Large object rights management