This is a discussion on Re: Failed assertion on cluster within the pgsql Hackers forums, part of the PostgreSQL category; --> On Sun, 6 Feb 2005, Larry Rosenman wrote: > > 1) alter table virtusers (and all the others in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |