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
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? |