How to auto generate id in postgresql on an existing column

How to create auto ID in PostgreSQL?Does Postgres automatically create ID?How to create auto increment in PostgreSQL? Read more →

An error occurred (InvalidSubnet) when calling the RestoreDBInstanceFromDBSnapshot operation: No default subnet detected in VPC

How do I restore a database from a snapshot and get the dbSubnetGroupName? Read more →

Is Terraform declarative or imperative and is it suitable for DB restore procedures ?

What is the difference between declarative and imperative IaC?What does declarative mean in Terraform?Is declarative or imperative better? Read more →

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 →