Tr: ERROR:cannot read block 9053 of mots

Поиск
Список
Период
Сортировка
От David D
Тема Tr: ERROR:cannot read block 9053 of mots
Дата
Msg-id OE10prhMOgRGkQ6mByS000018a3@hotmail.com
обсуждение исходный текст
Список pgsql-admin
> 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-admin по дате отправления:

Предыдущее
От: Ken Kinder
Дата:
Сообщение: Insert failures
Следующее
От:
Дата:
Сообщение: Consulta about BACKUP DB