Hi Sarwar
If you have WAL Files then you can decode them but that will be a tedious task.
Regards
Kashif Zeeshan
On Fri, Jun 7, 2024 at 8:44 AM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
Hi Tom,I do not have DDL logs.Are you saying that I should have manually maintain it or are you referring to any existing logs on the database side?This is taken very seriously by our architect. This guy behaves like everything like auditor, Project Manager or whatever we can think of. 🙂Thanks,Sarwar
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Sent: Thursday, June 6, 2024 9:14 PM
To: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to find the view modified date and time and user nameRon Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> What matters is that the DBA can see "ah, Bob altered table foo last
> Thursday at 14:30. Let's check the log file to see what he did."
I'm not finding that argument terribly convincing. If you have a
DDL log file, you can grep it to find the last change (and the
ones before that, in case it was Alice's fault not Bob's). If
you don't have such a log file, how much does a last-changed
timestamp really help you?
regards, tom lane