Re: tmp_pg_shadow

I am attempting to upgrade to 7.0.3 -- hence the dumpall command.

There was a zero size file in template1 that was causing the problem.
Thanks for the help.

<<Idiot... I should've thought of something simple like that>>

Thanks
-Rob

> Robert Dege <rcd@amherst.com> writes:
> > I'm trying to do a pg_dumpall & receive this error message:
> > ERROR:  cannot create tmp_pg_shadow
>
> Is it possible there is a physical file tmp_pg_shadow in your database
> directory?  If so, try removing it.
>
> BTW, I'd recommend an update to 7.0.3 at your earliest convenience...
>
>                         regards, tom lane