Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

aws

Home » aws
Read more about the article Using SSL to securely connect to Amazon Redshift Cluster

Using SSL to securely connect to Amazon Redshift Cluster

  • Post author:Amit Bansal
  • Post published:11 September, 2020
  • Post category:AWS/Cloud
  • Post comments:0 Comments

Amazon Redshift is fully managed Cloud Datawarehouse from AWS for running analytic workloads. Lot of customers have requirements to encrypt data in transit as part of security guidelines. Redshift provides…

Continue ReadingUsing SSL to securely connect to Amazon Redshift Cluster
Read more about the article AWS Glue Python shell job timeout with custom Libraries

AWS Glue Python shell job timeout with custom Libraries

  • Post author:Amit Bansal
  • Post published:13 June, 2020
  • Post category:AWS/Cloud
  • Post comments:0 Comments

This is short post on Timeout errors faced using custom libraries with AWS Glue Python shell job.  I referred the steps listed in AWS docs to create a custom library…

Continue ReadingAWS Glue Python shell job timeout with custom Libraries
Read more about the article Identifying PostgreSQL Bloat and fixing it without downtime

Identifying PostgreSQL Bloat and fixing it without downtime

  • Post author:Amit Bansal
  • Post published:21 April, 2019
  • Post category:PostgreSQL
  • Post comments:0 Comments

MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it was some time ago,…

Continue ReadingIdentifying PostgreSQL Bloat and fixing it without downtime
Read more about the article Saving AWS RDS and Redshift Billing Costs using Reserved Instances

Saving AWS RDS and Redshift Billing Costs using Reserved Instances

  • Post author:Amit Bansal
  • Post published:16 March, 2019
  • Post category:AWS
  • Post comments:0 Comments

  In this post, we would understand what are reserved instances, when do you need them and various ways to monitor them in your environment. As more enterprises are embracing…

Continue ReadingSaving AWS RDS and Redshift Billing Costs using Reserved Instances

Linux: ssh equivalence and SELinux

  • Post author:Amit Bansal
  • Post published:12 June, 2018
  • Post category:Unix
  • Post comments:0 Comments

This is quick post summarizing issues encountered while setting up ssh equivalence on EC2 instance. I was setting up  RHEL7 EC2 instances and followed below procedure to setup ssh equivalence…

Continue ReadingLinux: ssh equivalence and SELinux
Read more about the article Querying RDS PostgreSQL logs using Amazon Athena

Querying RDS PostgreSQL logs using Amazon Athena

  • Post author:Amit Bansal
  • Post published:27 April, 2018
  • Post category:AWS/PostgreSQL
  • Post comments:0 Comments

PostgreSQL logs contains useful information which can help in troubleshooting performance issues,auditing and performing historical analysis. Some of items which can be logged are listed below Client connection and disconnection…

Continue ReadingQuerying RDS PostgreSQL logs using Amazon Athena
  • 1
  • 2
  • Go to the next page
Copyright - OceanWP Theme by OceanWP