Re: Failed assertion on cluster

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Failed assertion on cluster
Date: 2005-02-06 17:45:42
Message-ID: Pine.uw2.4.61.0502061143300.5243@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 6 Feb 2005, Larry Rosenman wrote:

>
> 1) alter table virtusers (and all the others in that db) set without oids;
> 2) changed postgresql.conf's default_with_oids to false.
>
> Based on my read, this case is what's causing the grief.

To get me out of it:
pg_dump exim >exim.db
psql template1
alter database exim rename to exim_broken;
create database exim
\c exim
\i exim.db

and now I can cluster it :)

I still have the exim_broken files, and DB available if someone wants to look
at it.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-06 18:04:21 Re: Failed assertion on cluster
Previous Message Tom Lane 2005-02-06 17:36:45 Re: Patch Count?