Tobias Lott <[email protected]> writes:
> There were no crashes of the instance, but some issues with the connected
> application, resulting in 'could not receive data from client: Connection
> reset by peer' and 'unexpected EOF on client connection with an open
> transaction'.
No, that sort of thing would still allow the backend to shut down cleanly.
> So if this might have left behind temp tables causing the errors, should I
> try to delete these pg_temp tables?
It would definitely be worth looking around to see if you have any temp
tables that shouldn't be there. I think you can just do
\dt pg_temp_*.*
in psql (as superuser) to see what's out there. Figuring out which ones
are live sessions' temp tables might be harder, though.
regards, tom lane
