> 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 > > >
