Postgres Pro
Downloads
Home   >   mailing lists

Vacuudb problem - Mailing list pgsql-general

From Igor
Subject Vacuudb problem
Date
Msg-id 1502624494.20010510085536@osb368.nnov.ru
Whole thread Raw
In response to SHOW with libpq  (Limin Liu <limin@pumpkinnet.com>)
Responses Re: Vacuudb problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Vacuudb problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Mark Cowlishaw"
Date:
Subject: Re: ALTER COLUMN
Next
From: Tom Lane
Date:
Subject: Re: Vacuudb problem