You can stop the postmaster and start the postgres binary with the -O
flag and delete the pg_temp tables. We don't have a cleanup for these
failed backends but we should. Normally they are cleaned up.
---
Daniel Kalchev w
I found out, that there are some probably temporary relations in one of my
databases, with names (that show in vacuum verbose output) like
pg_temp.12720.0.
Are these the result of CREATE TEMP TABLE or simmilar and if so, can such
relations be safely dropped? Perhaps a good idea to add some vac
