Monitor the ddl and dml activities in logs

On Mar 6, 2019, at 5:58 AM, Nanda Kumar <Nanda.Kumar@smartstream-stp.com> wrote:

Hello Team,

I would like to know where I can monitor the ddl and dml operations happens in the production environment .

The documentation is your friend, particularly https://www.postgresql.org/docs/9.6/runtime-config-logging.html. By setting log_statement appropriately, you can see ddl and dml in your server logs.

On 3/6/19 5:58 AM, Nanda Kumar wrote:

Hello Team,

I would like to know where I can monitor the ddl and dml operations
happens in the production environment .

FYI - We are using Postgres 9.6 RDS database .

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.PostgreSQL.html

Regards

*Nanda Kumar.M*

SmartStream Technologies

Eastland Citadel | 5th Floor | 102 Hosur Road | Banglore 560 095 | India

nanda.kumar@smartstream-stp.com <mailto:nanda.kumar@smartstream-stp.com>
| www.smartstream-stp.com

Mob

+91 99720 44779

Tel

+91 80617 64107

------------------------------------------------------------------------
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it, is prohibited and may be unlawful.

--
Adrian Klaver
adrian.klaver@aklaver.com