I'm trying to add audit capability to Postgresql server. When the Postgresql server starts up, the server will start audit functions as a new subprocess thus the server will have 5 subprocesses instead of 4. I want to store logs in a database within the same Postgresql server [from audit subprocess, this means connection functions are part of the audit process].
Problem is that when I tried to connect to server [using libpq interface] I've always get this message:
"canceling authentication due to timeout",
but if I ran the same code as a new process [not a subprocess for Postgresql server] there will be no problem!
Now, my question is : How can I connect to server from one its subprocesses, is it even possible?