Re: Vacuudb problem

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