"David Levy" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org