I have been reading a lot about microservices and have been trying to logically split my system design up accordingly.
For the most part, my system will have a central database whereby I will have some triggers on important entity tables that will create an audit of all changes to the data. This trigger will write a log to the same database but in some separate tables.
I think that this data should exist in a separate database in another microservice. Is my thinking here correct with keeping with microservices architecture? What is the best way to move this data to another microservice? A batch job that runs every x minutes that moves the records to the audit microservice? I would like this data to be shipped to the auditing microservice as quick as possible. Does Postgres have a built-in function for this?