Re: How to find the view modified date and time and user name
| От | Ron Johnson |
|---|---|
| Тема | Re: How to find the view modified date and time and user name |
| Дата | |
| Msg-id | CANzqJaBAA5S+wVhnvqhNubxKP2Sj0_oA_uKCDh4VjPJNx=1PwA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to find the view modified date and time and user name ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: How to find the view modified date and time and user name
Re: How to find the view modified date and time and user name |
| Список | pgsql-admin |
On Thu, Jun 6, 2024 at 5:49 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thursday, June 6, 2024, M Sarwar <sarwarmd02@outlook.com> wrote:Hello,Today in our environment, we noticed that view is altered by someone.We want to know the date, time and modified user name.Our environment :1. aws / rds2. Postgress 13.53. database with default configuration is runningWe have not enabled any additional audit, security on top of default configuration.I have check led aws / rds / Instance / database / logs and events / log / all today's logsand could not find any evidence.Any hint / help will be greatly appreciated.If you didn’t take steps to record such information it doesn’t exist.
Which is a shame. pg_class (and other relevant catalog tables) should store created_on, created_by, last_modified_on and last_modified_by.
"But pg_restore does CREATE TABLE!! That's not when you _originally_ created the table."
How often do you run pg_restore? Developers certainly do it a lot, but our production systems have tables that were created six years ago when we migrated from 8.4 to 9.6. Is that when they were originally created? Doesn't matter.
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."
В списке pgsql-admin по дате отправления: