All Questions
Tagged with audit postgresql
19 questions
0
votes
0
answers
111
views
pgAudit Install Not Working Because of Makefile (Postgres 15)
Hi My Makefile supposedly doesnt have an install target. How do I fix this?
I dont understand how it even worked for others. Also, I cant use an updated version of Postgres due to restrictions at my ...
- 1
0
votes
1
answer
126
views
are pg_cron and pgaudit database specific extensions? or is one installation per server enough?
I'm quite versed in postgresql, but new to any extension other than postgis. for example, one of the first things I do when setting up an instance is to install postgis in template1, so it's available ...
- 185
0
votes
1
answer
75
views
Point-in-Time-Recovery of Postgres at an arbitrary time for audit purposes [closed]
TL;DR
Would you recommend using CDC or pg_wal-based recovery to reproduce the state of the database in an arbitrary time, or stick with joining SCD2 tables (with start end end date for every record) ...
0
votes
1
answer
64
views
Which are the options I have to create a structured log of all INSERT, UPDATE and DELETE from all tables of my PostgreSQL database?
With MySql, I'm using replication api to record all changes from my database.
pymysqlreplication and https://github.com/nevill/zongji are what I'm using.
I wonder which are the options I have to do ...
- 1
2
votes
2
answers
2k
views
Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?
I've been reading about postgresql replication and was wondering if it was somehow possible to listen to the replication binary log and push that to some tool like sumologic or splunk so that any ...
- 121
0
votes
0
answers
416
views
Postgres Audit Table
Is it good practice to use a table in Postgres as an audit log for login events? The database has other tables like users, posts etc. If the backend receives a failed login, it would insert into the ...
- 193
2
votes
2
answers
811
views
History table design for deletions in PG 11.5
I've got a question about the design of a history table in Postgres.
The setup is that I've got a table that holds a needs list. A location recalculates in-demand items every five minutes, and pushes ...
- 939
1
vote
1
answer
408
views
Audit trigger 91plus: setting up with proper role?
One of the solutions available for auditing in PostgreSQL is Audit trigger 91plus.
wiki page
github page
There is a section in the wiki that is confusing to me:
Changes by the table owner and ...
- 755
1
vote
0
answers
43
views
How to measure durations (import, update) in Postgres DB?
we have a Postgres database which receives data by an extern web client. We would like to measure the duration of the UPDATE, INSERT and DELETE processes on our tables.
Until now, we used the ...
33
votes
4
answers
59k
views
Track all modifications to a PostgreSQL table
We have a table which has only roughly 500 rows, but it is very important for us.
I want see all changes which happen to this table. The changes should get tracked with a timestamp.
I don't want the ...
- 1,621
2
votes
1
answer
10k
views
missing FROM-clause entry for table in trigger function in postgresql
I have created an audit trigger for table "product" that should insert data into "log_product".
CREATE FUNCTION public.insert_log_product()
RETURNS trigger
LANGUAGE 'plpgsql'
COST 100
VOLATILE NOT ...
- 153
5
votes
2
answers
5k
views
Getting the only updated field using a postgreSQL trigger?
Is there any way to use a trigger which can get the only updated field from a record? I am just testing the audit trail log so it can save the field name alongside its other information when it is ...
- 532
1
vote
1
answer
956
views
Database design. And get last modified time with each column in PostgreSQL
My database/table each endpoint/scope have multiple table,
e.g user: user, user_information, user_role ...
I was wondering should I separate table like below, or not?
This is my first time to ...
- 121
0
votes
1
answer
1k
views
Who deleted a record?
Is it possible to audit a Postgresql 9.4.5 database in such way that I could find when a specific record was deleted? I don't know what do I need to have enabled / available for such
- 1,059
2
votes
0
answers
4k
views
Storing table history - is this a good use case for Postgres's table partitioning / inheritance?
I currently have a products table which stores product information (title, description, tags, manufacturer, etc.) for a website. I would like to store historical information of changes to this table -...
- 183