Questions tagged [amazon-rds]
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
amazon-rds
7,086
questions
0
votes
0
answers
4
views
AWS RDS - How to get different Users
I have an aws Fargate environment which is accessed by different URL's (project1.tld; project2.tld ...).
There is one database per project in an Aurora DB cluster.
Each database should have a project ...
-1
votes
0
answers
9
views
listing aws rds instance types
When calling this API, the response is significantly delayed, especially for the MariaDB engine. What could be causing this, and how can I resolve it?
const rdsClient = new RDSClient(awsCredentials);
...
0
votes
0
answers
27
views
Inaccessible-encryption-credentials-recoverable status of AWS RDS instance
Inaccessible-encryption-credentials status of AWS RDS instance, though KMS key is enabled what could be the reason?
0
votes
0
answers
27
views
How to connect to AWS RDS Postgres via Node.js running on local machine
I have a Node.js app running on an ES2 instance which I can connect successfully to an AWS RDS Postgres database and run a SQL statement to return the results. Now I want to run that same app but on ...
0
votes
1
answer
37
views
Unable to connect from MySQL Workbench to AWS RDS instance
I have created a MySQL instance in AWS and trying to connect with it from MySQL workbench from my local system.
I made the MySQL instance publically accessible, added a security group and set inbound ...
0
votes
1
answer
31
views
PostgreSQL Trigger Procedures Asynchronously From Main Overall Procedure
I am currently working on building a pipeline using a PostgreSQL DB hosted by AWS RDS. In my pipeline, I have a stored procedure in PostgreSQL that is triggered by cron and used to executed other ...
0
votes
0
answers
25
views
Updating AWS RDS Proxy Certificates - what is the difference between normal RDS and RDS Proxy?
According to the AWS Docs:
RDS Proxy uses certificates from the AWS Certificate Manager (ACM). If you are using RDS Proxy, you don't need to download Amazon RDS certificates or update applications ...
0
votes
0
answers
16
views
External MySQL Master and a regularly called AWS slave is this possible?
I'm working for a client, we handle food related orders
We are having problem in our server during peak hours (5PM - 8PM) and we are evaluating proposition to scale this server.
We are trying to keep ...
0
votes
0
answers
36
views
How to Work with CLR Assemblies in AWS RDS SQL Server 2019 with CLR Strict Security Enabled
I'm facing challenges executing a CLR assembly in AWS RDS SQL Server 2019. Due to the enforced CLR strict security, I'm unable to mark the assembly as trusted using sp_add_trusted_assembly as it ...
0
votes
0
answers
17
views
Unable to Connect to AWS RDS (postgresql) from GitHub Codespaces Using IPv4
I am currently using GitHub Codespaces for my development environment. My setup involves an IPv6 VPC connected to an AWS RDS instance.
When I attempt to connect to the RDS instance using the following ...
-2
votes
0
answers
24
views
Need to automatic start and stop beanstalk and RDS daily [closed]
i have developed one e-commerce web application using below technologies and need to deploy in mentioned AWS services
Type Technology AWS Service
Frontend next.js ...
0
votes
0
answers
31
views
AWS RDS Blue-Green Deployment replication error: role "rdsrepladmin" cannot SET ROLE to "rds_superuser"
I am trying to use the AWS managed Blue-Green deployment feature on my Postgres RDS db. However, I keep getting an error about role "rdsrepladmin" cannot SET ROLE to "rds_superuser"...
0
votes
1
answer
42
views
Migartion of data from oracle DB to postgreSQL DB
I have a requirement to migrate data from AWS RDS Oracle DB instance to on-prem PostgreSQL DB,
I have manually created DB tables in PostgreSQL (replica of Oracle tables) now I'm trying to load the ...
0
votes
1
answer
11
views
RDS Permissions through IAM user
My RDS user lacks the permissions to create schema's. Is it possible to grant this user these permissions through an IAM policy instead of granting me these permissions via the Database administrator? ...
0
votes
0
answers
27
views
AWS RDS PostgresSQL not connecting with pgadmin but Dbeaver
I am facing an issue with AWS RDS Postgres connectivity from PGAdmin/psql command/web application
Background:
Created an AWS RDS PostgresSQL database
Made it public
Created inbound rules to allow all ...