Monday, June 11, 2018

[google-cloud-sql-discuss] Without superuser, how can I terminate rogue sessions?

So Cloud SQL for PostgreSQL creates the postgres user as a non-superuser. This means that I can't view what queries other sessions are executing in pg_stat_activity, and also means that I can't cancel/terminate sessions that might be zombied or runaway sessions.

Just want to make sure I didn't miss something, but is there a way to accomplish these things in Cloud SQL for PG?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0bab2b71-35bb-4e7a-af20-5420086e3a52%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment