Sample Header Ad - 728x90

how can I divide log files for specific DB queries?

0 votes
1 answer
503 views
Currently my db has a couple of triggers for some (not all) tables that get executed when a specific number of columns has been updated. I keep track if the triggers for those rows on a boolean column in the tables. Id like to be able to log UPDATE and INSERT queries and the errors/warnings coming from them onto different files in my postgresql server as a singular log file can get quite big. Ive thought of a couple of approaches to this problem and am looking for a better approach than these; - have the triggers (plpython3) create seperate log files when they only get called (not a lot but they insert millions of rows onto different tables. - write additional triggers that insert logging information onto another table (either by explicit means or a single JSON column) thank you for your time and answers!
Asked by Eiron (103 rep)
May 28, 2019, 07:30 PM
Last activity: May 29, 2019, 06:17 AM