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 wrote: > 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 vacuum > functionality to do this. > > Daniel > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
