hm ok, thank you Tom.
As you mentioned, I think it is not really possible to find out which of the sessions should be there and which not.
Also, as it is a Cloud SQL instance in GCP, I don't have access to a user with superuser attributes.
Best regards,
Tobias
On Wed, 3 Mar 2021 at 17:33, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Tobias Lott <tobias.lott@xxxxxxxxxxxx> 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
| Tobias Lott | |
| Technical Consultant | |
| Region South West | |
| +49 151 23649035 | |
| tobias.lott@xxxxxxxxxxxx | |
