Embedded Files
RDS for PostgreSQL is a fully managed database service from AWS. However there are still some DBA tasks required...
https://aws.amazon.com/blogs/database/common-administrator-responsibilities-on-amazon-rds-and-aurora-for-postgresql-databases/Database Information
Database Information
To find out key information about the RDS databases deployed in your AWS account...
aws rds describe-db-instances
Version
Version
aws rds describe-db-instances | grep -E 'DBInstanceIdentifier|Engine'
Parameter Group
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html Parameter Group
The parameter group is the AWS equivalent of the postgresql.conf file.
Database Log Files
NOTE: By default, RDS and Aurora instances retain logs for 3–7 days. (Optionally) run custom bash scripts to download the log files locally or to an Amazon EC2 instance or an Amazon S3 bucket to maintain log files for a longer period. Database Log Files
AWS recommend use of pgBadger (1).
An example pgBadger report can be found here: https://aws-database-blog.s3.amazonaws.com/artifacts/Common_DBA_responsibilities/postgres_sample.html
Maintenance and Management
Maintenance and Management
Autovacuuming
Long-running queries and sessions
Monitoring
Monitoring
CloudWatch
Performance Insights
Enable Enhanced Monitoring
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Monitoring.OS.htmlEnable Enhanced Monitoring
Via AWS Console...
Via AWS Console...
RDS - Database - Modify... In the Monitoring section click Enable Enhanced Monitoring. Choose rds-monitoring-role if it exists, otherwise choose Default and allow AWS to create the necessary IAM role automatically.
Bibliography
Bibliography
https://aws.amazon.com/rds/postgresql/https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/https://aws.amazon.com/rds/postgresql/what-is-postgresql/https://aws.amazon.com/blogs/database/tag/rds-postgresql/ https://docs.aws.amazon.com/vpc/latest/userguide/VPC_SecurityGroups.html
https://aws.amazon.com/blogs/database/common-administrator-responsibilities-on-amazon-rds-and-aurora-for-postgresql-databases/https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html
Backup/Recoveryhttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.htmlhttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
DRhttps://aws.amazon.com/rds/features/multi-az/
JDBChttps://jdbc.postgresql.org/download.html
Availabilityhttps://aws.amazon.com/rds/features/multi-az/
Monitoringhttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Monitoring.OS.html
RDS PostgreSQL to S3https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html
9.3https://forums.aws.amazon.com/ann.jspa?annID=5725
References
References
(1) https://aws.amazon.com/blogs/database/common-administrator-responsibilities-on-amazon-rds-and-aurora-for-postgresql-databases/
Page updated
Google Sites
Report abuse