What release are you running? My guess is that an upgrade will fix it.
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026