RDS instances are managed by Amazon. As such, to prevent you from breaking things like replication, your users – even the root user you set up when you create the instance – will not have full superuser privileges. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html When you create a DB instance, the master user system account that you create is assigned … Read more
First, note that you may be looking at the incorrect operation — you describe that you want to change storage size, but have quoted documentation describing storage type. This is an important distinction: RDS advises that you won’t experience an outage for changing storage size, but that you will experience an outage for changing storage … Read more
The issue was that the inbound rule in the Security Group specified a security group as the source. Changing it to a CIDR that included my IP address fixed the issue. Open the database security group in AWS; and choose “Edit inbound rules”; “Add rule”. There is a “My IP” option in the dropdown menu; … Read more
By default RDS does not allow any connection that is not specified within the Security Group (SG). You can allow based on CIDR addressing or by Amazon account number which would allow any EC2 under that account to access it.
It includes cached memory and memory used for buffers (besides what’s really free/unused). They’ll all be freed if an application requests more memory than what’s free.
The master user name can be recovered with the rds-describe-db-instances command. If you are using aws cli-2, command shall become : aws rds describe-db-instances –region ap-south-1
AWS RDS max_connections limit variable is based on Instance type, so you can upgrade your RDS or make more replica. The RDS types with max_connections limit: t2.micro 66 t2.small 150 m3.medium 296 t2.medium 312 m3.large 609 t2.large 648 m4.large 648 m3.xlarge 1237 r3.large 1258 m4.xlarge 1320 m2.xlarge 1412 m3.2xlarge 2492 r3.xlarge 2540 Referring by max_connections … Read more