Re: vacuumlo fails pgsql ver 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pat Heuvel <pheuvel(at)tpg(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumlo fails pgsql ver 8.3
Date: 2012-02-05 17:39:55
Message-ID: 17265.1328463595@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pat Heuvel <pheuvel(at)tpg(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Giuseppe Sacco 2012-02-05 22:30:04 Large object rights management
Previous Message Pat Heuvel 2012-02-05 17:24:54 vacuumlo fails pgsql ver 8.3