From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | "Jay W(dot) Summet" <jay(at)summet(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command) |
Date: | 1999-03-26 03:35:51 |
Message-ID: | Pine.BSF.4.05.9903252335330.389-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 25 Mar 1999, Jay W. Summet wrote:
> When I try to vacuum, or vacuum analyze my database, I get the
> following error:
> FATAL 1:btree: BTP_CHAIN flag was expected
>
> I've tried the following two commands:
> /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
> and
> /usr/local/pgsql/bin/psql -c "vacuum;" billing
>
> The top command used to work (for the last few years), so I assume
> that something has changed with my data. Otherwise, the database
> appears to be working ok.
>
> Any pointers? I'm thinking about dumping all the data and
> re-inserting it...
Try just drop'ng and rebuilding your indices...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-03-26 03:37:06 | RE: [GENERAL] info on people running postgre |
Previous Message | Jim Jennis | 1999-03-25 22:48:36 | Re: [GENERAL] Re: [SQL] sql 92 support in postgres |