Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] large object does not exist after pg_migrator

From: Jamie Fox <jfox(at)directcommerce(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] large object does not exist after pg_migrator
Date: 2009-07-15 21:22:49
Message-ID: de22a6520907151422h525abc48qce68618592754aad@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Worked great, vacuumlo finished, a vacuum -full finished amazingly quickly,
very exciting.  We're pointing qa apps at it now for testing.
For some reason though, that index has to be rebuilt after running
pg_migrator.

I'll be testing on our 100GB+ prod copy shortly and will let you know if you
want.

Thanks,

Jamie


On Wed, Jul 15, 2009 at 9:28 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>wrote:

> Jamie Fox wrote:
>
> > Hi -
> > REINDEX INDEX pg_largeobject_loid_pn_index;
> >
> > This seems to have fixed the problem, lo_open of lob data is working
> again -
> > now to see how vacuumlo likes it.
>
> So did it work?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

In response to

pgsql-hackers by date

Next:From: Fernando Ike de OliveiraDate: 2009-07-15 21:38:31
Subject: Re: [PATCH] Psql List Languages
Previous:From: Heikki LinnakangasDate: 2009-07-15 21:03:25
Subject: Re: Synch Rep for CommitFest 2009-07

pgsql-general by date

Next:From: Scott MarloweDate: 2009-07-15 21:55:36
Subject: Areca 1680 and RHEL/Centos 5.3 issue
Previous:From: Scott MarloweDate: 2009-07-15 20:24:25
Subject: Re: savepoints in 8.3.7 or whatever...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group