Vacuudb problem

From: Igor <dbmanager(at)osb368(dot)nnov(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuudb problem
Date: 2001-05-10 04:55:36
Message-ID: 1502624494.20010510085536@osb368.nnov.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Help me please to resolve my problem. It is during vacuuming
database .I resolved it last time in such a way: pg_dump and
psql -e db<db.archiv. But after some days it appeared again.
Here is messages :

NOTICE: mdopen: couldn't open pg_temp.2297.4: No such file or directory
NOTICE: RelationIdBuildRelation: smgropen(pg_temp.2297.4): No such file or directory
NOTICE: mdopen: couldn't open pg_temp.2297.4: No such file or directory
ERROR: cannot open relation pg_temp.2297.4
vacuumdb: vacuum failed

And one more question. Is there any way to encrease speed
of restoring database . psql -e works about some hours for me...

Thanks for any suggestions.

Igor

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-10 05:22:52 Re: Vacuudb problem
Previous Message Mark Cowlishaw 2001-05-10 04:35:01 Re: ALTER COLUMN