From: | Muhammad Ikram <mmikram(at)gmail(dot)com> |
---|---|
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 |
Date: | 2024-06-07 15:35:47 |
Message-ID: | CAGeimVrREVpW-_cxeZD9F0dmT60HP_bTUp6RHEHgxU3KzDnA1Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Wetmore, Matthew (CTR) | 2024-06-07 17:29:51 | RE: [EXTERNAL] Re: How to find the view modified date and time and user name |
Previous Message | Rui DeSousa | 2024-06-07 13:01:25 | Re: How to find the view modified date and time and user name |