Does anyone know how to look up the transaction/query that’s associated with an LSN on a CloudSQL Postgres instance?
For example, let’s say I’m trying to find the transaction associated with LSN
842/E62E3F01. On a normal server, I can ssh into the instance, and run
pg_waldump --start=842/E62E3F01 (or
pg_xlogdump on Postgres < 10). But it doesn’t seem possible to ssh into a CloudSQL server. If so, how can I find the query/transaction associated with this LSN on CloudSQL?