Implement FDW based data "escape hatch" for internal metrics and logs data

Question

Implement FDW based data "escape hatch" for internal metrics and logs data

sumerman opened this issue 2 years ago · 1 comments

Implement support for collecting data from rolled-back transactions FDW.

Answer 1 · 2022-08-31T09:54:31.000Z

@jgpruitt had a quick look and FDW doesn't seem like a way forward. To recap:

As expected, using postgres_fdw will not work as a rollback also rolls back the transaction on the foreign server.
AWS suggests using dblink_fdw . According to the article, Any SQL operation executed via a dblink is committed immediately regardless of the main transaction.
But, dblink is deprecated. So, that’s probably a no-go too.