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

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(at)outlook(dot)com> 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(at)gmail(dot)com>
> *Sent:* Friday, June 7, 2024 11:35 AM
> *To:* Rui DeSousa <rui(dot)desousa(at)icloud(dot)com>
> *Cc:* M Sarwar <sarwarmd02(at)outlook(dot)com>; Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>;
> Ron Johnson <ronljohnsonjr(at)gmail(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org <
> pgsql-admin(at)lists(dot)postgresql(dot)org>
> *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(dot)desousa(at)icloud(dot)com> wrote:
>
>
>
> On Jun 6, 2024, at 11:44 PM, M Sarwar <sarwarmd02(at)outlook(dot)com> 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