- Архив списков рассылки pgsql-general

Поиск
Список
Период
Сортировка
От zaviz2@hushmail.com
Тема
Дата
Msg-id 200102021117.DAA14565@user7.hushmail.com
обсуждение исходный текст
Список pgsql-general
hi,i'm sorry but
i don't speak english...but i have a problem:

    ERROR:cannot read block 9053 of mots

i do:
$ vacuumdb -v --table 'mots' moteur
NOTICE:  --Relation mots--
ERROR:  cannot read block 9053 of mots
vacuumdb: database vacuum failed on moteur.

so..

moteur=> VACUUM
moteur-> ;
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.

so..
    postgres stop
    postgres start

moteur=> vacuum;
NOTICE:  CreatePortal: portal <vacuum> already exists
ERROR:  Can't create lock file.  Is another vacuum cleaner running?
        If not, you may remove the pg_vlock file in the /usr/local/pgsql/data/base/moteur
        directory

rm pg_vlock

moteur=> vacuum verbose mots;
NOTICE:  CreatePortal: portal <vacuum> already exists
NOTICE:  --Relation mots--
ERROR:  cannot read block 9053 of mots

i don't know who command or util. to use for these pb
it's a hard pb ?

and if exist a french-list-site for postgres help ?????

thank you

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

Предыдущее
От: "Ian deSouza"
Дата:
Сообщение: Dates/Timestamps in a where clause
Следующее
От: "Per-Olof Petterson"
Дата:
Сообщение: Re: Foreign Keys