How to get rid of found orphan temp table in postgresql?

Question

PostgreSQL

The server under win 2003 crashed. Now postgresql won't start. Entries are pouring into the logs

2017-11-29 15:57:53 EET LOG: autovacuum: found orphan temp table "pg_temp_5"."tt1" in database "Polan"
2017-11-29 15:57:53 EET LOG: autovacuum: found orphan temp table "pg_temp_3"."tt1" in database "Polan"
....
2017-11-29 15:57:53 EET LOG: autovacuum: found orphan temp table "pg_temp_3"."tt34" in database "Polan"

googling says that you need to execute
DROP SCHEMA pg_temp_3 CASCADE
But how to get into the PG interface if it does not start
p.s.
If necessary, throw a link to a normal book on GHG

Answer 1

If necessary, throw a link to a normal book on GHG

The book that should be near the Russian-speaking admin - Working with PostgreSQL: setting up and scaling authorship of Alexey Vasiliev. Plus a related question on Toaster .
About your problem. To decide "what to do" should be a person with authority and admin access - that is. you, not some anonymous adviser. There are many topics on this topic on the Internet ( one of them ) and your task is to restore work by brute force (by the way, many write about the vacuum for deleting orphaned tables - you can start with it). In your story, I'm more confused by the phrase "The server under win 2003 crashed ". Nothing good awaits you until you restore the file subsystem to working order.