"David Levy" <dvid(dot)levy(at)gmail(dot)com> writes:
> I have a 7Go pgsql_tmp directory in my main tablespace which remains
> even after a cluster restart.
> Does anyone know how to clean up properly ? Can i just delete the
> directory in the filesystem (with the cluster up or down ?) ?
If the postmaster's not running, it's certainly safe to remove pgsql_tmp
files. However, unless you are running a pre-7.2 Postgres, the
postmaster should remove them for itself during startup; you should look
into why that's not happening. Permissions problem, perhaps?
regards, tom lane