cannot vacuum a database !

Поиск
Список
Период
Сортировка
От Ange Michel POZZO
Тема cannot vacuum a database !
Дата
Msg-id 00082910370001.03011@ange.alpinfo.fr
обсуждение исходный текст
Ответы Re: [GENERAL] cannot vacuum a database !
Список pgsql-bugs
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 : ange@alpinfo.fr
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/

******************************************************************************


В списке pgsql-bugs по дате отправления:

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: JDBC: allow update of Date-Columns with NULL
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [GENERAL] cannot vacuum a database !