Postgres Pro
Downloads
Home   >   mailing lists

Thread: Monitor the ddl and dml activities in logs

Monitor the ddl and dml activities in logs

From
Nanda Kumar
Date:

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 .

 

Regards

Nanda Kumar.M

SmartStream Technologies

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

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.

Re: Monitor the ddl and dml activities in logs

From
Ben Chobot
Date:

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.

Re: Monitor the ddl and dml activities in logs

From
Adrian Klaver
Date:
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