Re: tmp_pg_shadow - Mailing list pgsql-general

From Robert Dege
Subject Re: tmp_pg_shadow
Date
Msg-id 3A8ADF52.3C1C7C6D@comptekamherst.com
Whole thread Raw
In response to tmp_pg_shadow  (Robert Dege <rcd@amherst.com>)
Responses Re: Re: tmp_pg_shadow
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tmp_pg_shadow
Next
From: The Hermit Hacker
Date:
Subject: Re: News server not working?