"Gershon M. Wolfe" <gary(dot)wolfe(at)lsbc(dot)com> writes:
> I have a bunch of pg_noname.8204.0.x files in my
> database directory. These files are huge, they were
> created about a month ago, how do I get rid of them.
(a) manually remove 'em, they're just temp files.
(b) update to a more recent Postgres. We haven't generated temp files
with such names in a very long time.
regards, tom lane