Amazon RDS + Postgres – Activate slow query logs

  1. Login to your AWS console and go to RDS.
  2. From the left menu, select Parameter Groups
  3. Create a new parameter group for Postgres, by copying the default Postgres parameter group
  4. Edit the following parameters in the new group:
    Parameter Name                                              Value
    log_min_duration_statement                               250
    log_statement none
    log_duration 0
  5. Modify the RDS instance and apply the new parameters group.
  6. Beware – If you are applying group for the first time, it will require a RDS reboot.

YOu might also like this:

Establishing IPSec tunnel using Openswan tool on Amazon EC2

One of our client wanted to secure the communication between servers by encrypting it over an IPSec Tunnel. We struggled a lot to set this up initially due to lack of proper documentation. Hence we decided to share the steps with everyone.

Enterprise Mobility: A boon to boost your operations

Extraordinary product.. Exceptional technical team.. Efficient workforce.. But why are the revenues stalled? Or why aren’t they not upto the expectations? Have you ever thought of it? Do you know that three to four hours of your working time is wasted in admin work? And did you realise that it takes away 40% of your time in working?

Go digital with your retail operations!

The vision of today’s retailer is to simplify, enliven and customize shopper experience of the tech-empowered customers. To deliver an omnichannel customer experience, retailers must balance conflicting supply chain priorities and goals with ongoing optimization strategies and tactics.