database95Parameters:
  Type: AWS::RDS::DBParameterGroup
  Properties:
    Description: parameter group for services db
    Family: postgres9.5
    Parameters:
      # max_locks_per_transaction: to be able to pg_dump database (we have lots of tables in multiple schemas)
      # PG locks all these tables as it takes a pg_dump
      max_locks_per_transaction: 500
      log_min_error_statement: NOTICE # http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
      log_min_duration_statement: 900 # milliseconds
      rds.log_retention_period: 10080 # week
      work_mem: 5196 # 5mb, specified in kb. default 1mb.
      # possibly useful, turns on all statements. log_statement: all
database96Parameters:
  Type: AWS::RDS::DBParameterGroup
  Properties:
    Description: parameter group for services db
    Family: postgres9.6
    Parameters:
      # max_locks_per_transaction: to be able to pg_dump database (we have lots of tables in multiple schemas)
      # PG locks all these tables as it takes a pg_dump
      max_locks_per_transaction: 500
      log_min_error_statement: NOTICE # http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
      log_min_duration_statement: 900 # milliseconds
      rds.log_retention_period: 10080 # week
      work_mem: 5196 # 5mb, specified in kb. default 1mb.
      # possibly useful, turns on all statements. log_statement: all
#databaseSubnetGroup:
#  Type: AWS::RDS::DBSubnetGroup

database:
  Type: AWS::RDS::DBInstance
  DependsOn:
    - database96Parameters
    - databaseSg
  DeletionPolicy: Snapshot