Postgres Orphaned Temp Tables

LOG: autovacuum: found orphan temp table “pg_temp_23″.”a_temp_table_temp” in database “productiondb” I recently came across this issue after performing a PITR (Point in Time Restore) on a Postgres Instance. The Log message from autovacuum was throwing multiple times a second, and I don’t know about you but I couldn’t stand to let my log fill up ...