Getting log information from PostgreSQL

Question

My application uses PostgreSQL for storing data. I need to gather information about all user actions (any INSERTs, UPDATEs or DELETEs) executed on the database. This made me wonder whether PostgreSQL provides any default implementations/tables for this? As per my prior searches, I haven't found anything usable yet - however proper confirmation to my suspicions would be nice. If PostgreSQL truly doesn't provide any default implementations for this, then I will design my own history table.

Something that might also be of help here is PostgreSQL's Audit trigger. — Priidu Neemre
– Priidu Neemre, Commented Sep 12, 2014 at 12:04

Tuna · Accepted Answer · 2013-06-03 18:23:31Z

1

PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log destinations separated by commas. The default is to log to stderr only. This parameter can only be set in the postgresql.conf file or on the server command line.

SEE HERE

edited Jun 3, 2013 at 18:23

Tuna

2,9936 gold badges40 silver badges62 bronze badges

answered May 30, 2013 at 13:01

PSR

40.4k43 gold badges115 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

A.H. Over a year ago

The Q mentions "history table". I doubt an unstructured textual logfile will help here.

Collectives™ on Stack Overflow

Getting log information from PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related