Re: permission denied for pg_temp_XX when vacuuming

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Tobias Lott <tobias(dot)lott(at)devoteam(dot)com> 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 <+49+151+23649035>
tobias(dot)lott(at)devoteam(dot)com
[image: Banner EVP Intelligence]
[image: Devoteam at Linkedin] <https://www.linkedin.com/company/devoteam>
[image: Devoteam at Youtube]
<https://www.youtube.com/watch?v=Lrk4lQJ82bI&t=3s>
[image: Devoteam at Twitter] <https://twitter.com/devoteam>