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

Re: Orphan TOAST object

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Orphan TOAST object
Date: 2008-05-12 07:35:46
Message-ID: 20080512073546.GA30621@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi James,

On Mon, May 12, 2008 at 09:25:34AM +0200, James Farrugia wrote:

> First of all thanks for the immediate replies!
> Was actually waiting for the right moment to upgrade to 8.3 but migrating a
> live 1Tb database is a bit daunting especially if you have never done it
> before (as in my case).  If I'm not mistaken i can upgrade to the latest
> minor version without having to dump and restore so I'll do that.

You need to check the release notes of the particulra minor release you
are upgrading to. Some minor releases also require a dump/restore cycle
because of bugfixes. You're lucky: 8.2.7 doesn't require dump/restore in
your case, the release notes say:
"A dump/restore is not required for those running 8.2.X"

> One last thing...can we run into data-loss problems with successfully
> vacuumed tables even if there is one unvacuumed database object; what would
> have happened if I ignored to vacuum that rogue pg_toast (which was the only
> unvacuumed object within the entire database)?

At a certain point, the server would have switched to "emergency mode"
and wouldn't have accepted any commands any more. See the description
here:
http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

HTH,

Tino.

-- 
"What we resist, persists." (Zen saying)

www.craniosacralzentrum.de
www.forteego.de

In response to

Responses

pgsql-admin by date

Next:From: James FarrugiaDate: 2008-05-12 08:19:59
Subject: Re: Orphan TOAST object
Previous:From: James FarrugiaDate: 2008-05-12 07:25:34
Subject: Re: Orphan TOAST object

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