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(at)amherst(dot)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