tmp_pg_shadow

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

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 wrote:

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>>

Not too bad to ask anyway. We have seen people assuming
pg_log is some kind of unimportant logfile who thought
shrinking it is a good way to free some space - well it was
because it required an initdb run finally :-)

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com