Re: How to find the view modified date and time and user name

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello M Sarwar,

It's an extension you can install. Do some googling and you  will find steps

Regards,
Ikram


On Sun, Jun 9, 2024 at 9:35 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
Hi / AA Ikram,
Probably I will not be able to depend or organize thru pgdumps at this time. I am on Postgres 13.5 / aws-rds.
I am unable to find pgaudit from my client. Do you I need to install any additional sw for pgaudit?
Thanks,
Sarwar


From: Muhammad Ikram <mmikram@xxxxxxxxx>
Sent: Friday, June 7, 2024 11:35 AM
To: Rui DeSousa <rui.desousa@xxxxxxxxxx>
Cc: M Sarwar <sarwarmd02@xxxxxxxxxxx>; Tom Lane <tgl@xxxxxxxxxxxxx>; Ron Johnson <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to find the view modified date and time and user name
 
Hi M Sarwar,

If you have some dumps of the database in near past, then you may analyze those and note till what time view was in original state (May be narrowing down on things)
As some geek said above, this incident can serve as a lesson learnt and, for future you can configure pgAudit to capture all DDLs or set a log level that captures ddls e.g. log_statement = ddl

Regards,
Muhammad Ikram
Bitnine

On Fri, Jun 7, 2024 at 6:01 PM Rui DeSousa <rui.desousa@xxxxxxxxxx> wrote:


On Jun 6, 2024, at 11:44 PM, 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


A simple solution I used was to do a schema only dump daily and check in any changes into a git repo via a cronjob  Then the repo will track schema changes.


--
Muhammad Ikram



--
Muhammad Ikram


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux