Re: Autonomous transaction, background worker

2018-03-28 Thread Thiemo Kellner
I've experimented with background workers a bit. Yes, normally you'd write some C, but you could also install this (mentioned in the blog post and the source of pg_background_launch): Thanks for your answer. I want my logger to be used with the facilities there are from PostgreSQL so I'll go t

Re: Autonomous transaction, background worker

2018-03-27 Thread Paul Jungwirth
I try to setup a logging facility and want it to do its work asynchronously in autonomous transactions. I have read http://blog.dalibo.com/2016/08/19/Autonoumous_transactions_support_in_PostgreSQL.html and chapter 47 of the documentation believing those articles are about the same. However, pg_