"David Levy" <dvid.levy@xxxxxxxxx> 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
