7,115
questions
0
votes
0
answers
6
views
Create an alert on replication slot for RDS
Is it possible in AWS to create an alert on an inactive RDS Postgres replication slot ? Could you provide some guidelines?
Thanks
- 520
0
votes
0
answers
7
views
Cross Account RDS Backups: KMS Strategy
I am in the process of defining our KMS key strategy in our AWS multi-account environment, specifically for use with RDS Aurora and AWS Backup.
I need to make use of a Customer key for our RDS storage ...
- 826
-1
votes
1
answer
20
views
how to know the details of the connections in AWS RDS? [closed]
In the current activity section of the AWS RDS i am noticing the number of connections. But i need more information of the connection (where is it from etc).
I am expecting any suggestions which i ...
0
votes
1
answer
22
views
Python RDS DB2 connection: TypeError: Class com.ibm.db2.jcc.DB2Driver is not found
I'm trying to connect to a DB2 instance running in RDS using Python.
I rely on jaydebeapi for that and rely on the doc.
Despite several tries, I still facing the issue in title.
My code is below. Any ...
0
votes
0
answers
57
views
How to Safely Deploy and Migrate a PostgreSQL Prisma Schema to a Production Database with Docker, EC2, and AWS RDS Without Downtime?
I am working on deploying the latest changes from our staging environment to our production environment. We’re using PostgreSQL with Prisma for database management, and our setup involves Docker ...
- 1
0
votes
1
answer
20
views
Logical replication issue in AWS RDS Postgresql
I am trying to set up PostgreSQL's inbuilt logical replication from one AWS RDS instance to another. A new user was created for this -
CREATE ROLE my_replication WITH
NOSUPERUSER
NOCREATEDB
...
- 1,334
-1
votes
0
answers
33
views
CDK RDS DatabaseInstanceReadReplica missing 'engine' property
I am trying to deploy a very simple RDS Primary/Replica standalone instance setup (Not Aurora).
The code to create the primary and replica instances looks like this:
this.rdsPrimaryInstance = new ...
- 549
0
votes
0
answers
15
views
Connection attempt timeout when connecting to Postgres DB using IAM Authentication
"I have enabled IAM authentication on my database. When trying to connect using a token, I initially receive a 'connection attempt timeout' error. However, after several attempts (3-6 tries), the ...
0
votes
0
answers
44
views
Could not connect to server: Error 1045: Access denied for user 'admin' [closed]
I have been struggling with this for several days. When trying to set up databases inside the RDS instance which is inside a privately subnetted VPC, I can't seem to connect to the instance to put the ...
1
vote
1
answer
26
views
Error while setting up pgactive extension
I am following the AWS's documentation to setup pgactive extension and have an active-active setup on two AWS RDS Postgres instances. Following all the steps successfully till step 11 where it asks to ...
- 439
0
votes
0
answers
56
views
GCP database migration fails while recreating indexes
I created a continuous database migration job from an AWS RDS MySQL database to GCP Cloud SQL instance. Everything seemed to go well, until 8 hours in, I notice the new database size went to 0 and I ...
- 1,019
0
votes
1
answer
35
views
JDBC Connection attempt failed in aws Glue notebook while Test Connection succeeds
I can't manage to access postgresql RDS via python notebook in aws glue.
I have setup a security group with all ingress tcp allowed with the source being the security group itself. All outbound is ...
- 1,325
0
votes
1
answer
26
views
AWS PostgreSQL "FATAL: remaining connection slots are reserved for non-replication superuser connections" After Upgrading .NET Version
I'm encountering an issue with my application hosted on AWS after upgrading from .NET 6.0 to .NET 8.0. My application is running in a Docker container.
After the upgrade, I started receiving the ...
- 11
0
votes
2
answers
210
views
Trouble Upgrading MySQL 5.7 to 8: The auxiliary tables of FTS indexes on the table are created in system table-space due to bug
My team and I are attempting to upgrade our multi-tenancy AWS RDS/MySQL instance from MySQL 5.7 to 8. After trying the upgrade, we received a report showing a large number of errors for the customers, ...
- 888
0
votes
0
answers
35
views
Error when connecting to Amazon RDS using pymysql: Database connection failed Cannot set verify_mode to CERT_NONE when check_hostname is enabled
I am trying to connect to Amazon RDS using mySQL but I am getting an error message for pymysql connect. The code I have used is:
conn = pymysql.connect(auth_plugin_map={'mysql_clear_password': None}, ...
