try 'vacuum verbose;' ... if that doesn't work, try doing a pg_dump/reload
... and, above all ... upgrade to v7.x as soon as possible ...
On Tue, 29 Aug 2000, Ange Michel POZZO wrote:
> hi all,
>
> i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] on a
> linux mandrake 7.0
>
> after i have drop some tables and index i don't use, i c'ant do a vacuum on the
> database.
>
> here is the error :
>
> [me@www me]$ psql mydb -u
> Username: postgres
> Password:
>
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2]
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: mydb
>
> mydb=> vacuum ;
> NOTICE: Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1021) IS NOT THE SAME
>AS HEAP' (1022)
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.
>Terminating.
> [me@www me]$
>
> ...
>
>
> mydb=> \d pg_proc_prosrc_index
> Table = pg_proc_prosrc_index
> +----------------------------------+----------------------------------+-------+
> | Field | Type | Length|
> +----------------------------------+----------------------------------+-------+
> | prosrc | text | var |
> +----------------------------------+----------------------------------+-------+
> mydb=>
>
>
> what should i do now ?
> is my database corrupt ?
>
> any idea ?
>
> thanks for any help !
>
> ANGE
>
>
> --
>
> ******************************************************************************
> POZZO Ange Michel
> mail : [EMAIL PROTECTED]
> Administrateur - Développeur
> ALPINFO
> 617 Rue Denis Papin
> 73290 La Motte Servolex
> Savoie - France
> tel : 04 79 26 06 28
> fax : 04 79 25 68 36
>
> Zonecommerce, l'annuaire français du commerce électronique
>
> - Plusieurs centaines de magasins référencés pour tous vos achats
> sur internet, tous avec paiements sécurisés en ligne
> - Des promotions proposées par les boutiques
> - Vente aux enchères, forum de discussion
> - Des actualités, sports et loisirs, cinéma, horoscope ...
> - Les iddées d'olivia, le site du mois, l'interview
> - Des liens, des conseils ...
>
> http://www.zonecommerce.com/
>
> ******************************************************************************
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
