Home > mailing lists

How to find the view modified date and time and user name - Mailing list pgsql-admin

From	M Sarwar
Subject	How to find the view modified date and time and user name
Date	June 7 00:06:05
Msg-id	DM4PR19MB597864190796CC5828854176D3FA2@DM4PR19MB5978.namprd19.prod.outlook.com Whole thread Raw
Responses	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
List	pgsql-admin

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 / rds

2. Postgress 13.5

3. database with default configuration is running

We 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 logs

and could not find any evidence.

Any hint / help will be greatly appreciated.

Sarwar

Sent from my Galaxy

From: Ron Johnson
Date: 06 June, 16:33:07
Subject: Re: Minimize checkpointer and walwriter io during pg_restore

From: M Sarwar
Date: 07 June, 00:11:48
Subject: RE: How to find the view modified date and time and user name