All Questions
Tagged with aws-cli amazon-rds
80 questions
1
vote
1
answer
1k
views
aws rds enable-http-endpoint not changing flag of postgres db cluster
I am running a postgres db cluster on aws and I'd like to allow an ec2 instance to make programmatic changes to the database. When I try to run the program I get the following error:
"botocore....
1
vote
0
answers
65
views
RDS instance engine name versus pricing get-products databaseEngine name
I am trying to get the pricing info for RDS instances. The problem I have is that I get the instances from the aws-sdk with 'rds describe-db-instances' which returns me an engine name of the format:
...
0
votes
1
answer
444
views
How do I find RDS clusters with 0 instances?
In the RDS UI, you can see clusters and easily identify those with 0 instances. I'm trying to query RDS using AWS CLI, but I don't see anything offhand that will help me find that value.
I briefly ...
0
votes
2
answers
1k
views
How to use the --query and --filters with aws rds describe-db-instances to retrieve the OptionGroupName value of an RDS
I would like to retrieve the DB Option Group (OptionGroupName) for an RDS by using the aws rds describe-db-instances --query and --filters.
Just FYI I can not use jq to filter the json response from ...
- 83
3
votes
1
answer
819
views
How do you specify from the AWS CLI/API what VPC an RDS Snapshot is restored to?
I have 2 VPCs, one default and one for my DBs. If I run this command:
aws rds restore-db-instance-from-db-snapshot --db-instance-identifier test --db-snapshot-identifier db-arn --vpc-security-group-...
- 794
1
vote
1
answer
1k
views
AWS RDS Serverless error: Set vpc security group for the DB Cluster
aws rds create-db-instance
aws rds create-db-instance \
--db-instance-identifier dashboard-db-instance-22-1 \
--db-instance-class db.serverless \
--engine aurora-postgresql \
--...
- 3,898
1
vote
2
answers
554
views
MasterUserSecret field missing in describe-db-instances API
I have created the database with ManageMasterUserPassword=True. But I couldn't get the Secret Arn from the describe-db-instances command.
aws rds describe-db-instances --db-instance-identifier ...
- 1,326
0
votes
1
answer
479
views
How to list all the RDS snapshots through CLI and import some of those fields into a spreadsheet
I need to list all these ( ( DBSnapshotIdentifier , DBInstanceIdentifier, AvailabilityZone , SnapshotType , Encrypted , SnapshotCreateTime) properties of both automated and manual snapshots of all the ...
- 1
0
votes
1
answer
424
views
How can I get the name of the all snapshot of RDS DB instance created manually using the AWS CLI?
How can I get the name of the all snapshot of RDS DB instance created manually using the AWS CLI?
I am using below command
aws rds describe-db-cluster-snapshots \
--query "sort_by(...
0
votes
2
answers
378
views
AWS RDS. How to copy/move/migrate Parameters/options groups vetween aws accounts?
I have a lot of parameters options groups in RDS service. So, how can I copy it between AWS accounts?
I didn't find any aws cli commands for it, so may be there is some third-party solutions?
Thanks ...
- 1
1
vote
2
answers
3k
views
How to list all AWS RDS instances and their tags in CSV
I'm new to the AWS CLI and I am trying to build a CSV server inventory of my project's AWS RDS instances that includes their tags.
I have done so successfully with EC2 instances using this:
aws ec2 ...
- 21
0
votes
1
answer
210
views
How to display a drop-down list of RDS instance snapshot ID's when creating a new stack from a template?
I wrote a CloudFormation template which creates a Postgres instance and restores data from a previously backed up DB instance snapshot.
I want to enable the user which is going to work with this ...
0
votes
1
answer
638
views
Get more than one metrics using single aws cloud-watch command CLI?
How to get the multiple RDS metrices in one CLI command instead of executing various commands?
Example:
I need CPU utilization, FreeStorageSpace, and FreeableMemory stats in single call cli
I used:
...
- 41
0
votes
2
answers
3k
views
Unable to connect to AWS RDS using AWS CLI - Error 2002
I've set up a basic AWS RDS in the free tier. No public access but created a security group with my IP address added as an inbound rule.
For authentication I have RDS password plus AWS IAM.
I try to ...
- 3,938
1
vote
1
answer
496
views
AWS CLI: cannot restore-db-cluster-to-point-in-time with "--serverless-v2-scaling-configuration"
John@MacBook-Pro:~/IWG/code$ aws rds restore-db-cluster-to-point-in-time \
--restore-type full-copy \
--source-db-cluster-identifier mySourceCluster \
--db-cluster-identifier myTargetCluster \
--...
- 3,683