How to drop all tables in a schema in PostgreSQL?

How do I drop all tables in a SQL schema?How to drop all tables in a schema in postgres? Read more →

What is option group and parameter group in RDS ?

What is an Option group in AWS?What is a parameter group in AWS? Read more →

AWS Shared Account Model

what is a shared account in AWS? can one AWS account have multiple users?What is the best way to to share your AWS account with your team? Read more →

AWS SCT Global settings - Cannot add Windows Authentication Library

How configure AWS SCT for Global Settings - Windows Authentication Library ? Read more →

Does DMS migrate PostgreSQL geospatial data types ?

Does Database Migration Service (DMS) migrate PostgreSQL geospatial data types ? What are the best practices for homogenous migrations? Read more →

The default write concern may change when upgrading to 5.0

Question: After an upgrade from MongoDB 4.4 to MongoDB 5 some start up warning signs have appeared . {"t":{"$date":"2023-01-20T13:35:05.354+00:00"},"s":"I", "c":"REPL", "id":5569202, "ctx":"ReplCoord-0","msg":"** WARNING: The default write concern may change when upgrading to 5.0. Use setDefaultRWConcern to set a cluster-wide default write concern that won't change.","tags":["startupWarnings"]} What is the fix ? Answer: db.adminCommand( { setDefaultRWConcern : 1, defaultWriteConcern: { "w" : "majority" } } ) Read more →

RDS Client: DB Instance quota exceeded

how many DB instances can run on RDS? How do I increase the number of RDS Instances? Read more →

AWS Backup continuous backup - RDS, DynamoDB , Aurora

What is continuous backup in AWS? What are the differences in Continuous backup for RDS, DynamoDB & Aurora Read more →

Amazon DynamoDB Backup & Restore

Does DynamoDB have backup?Is DynamoDB backup by default? Read more →

Amazon RDS DB Instance storage

What types of storage types are supported by RDS? What types of instances are supported ? Read more →