Questions in Database
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I am trying to upgrade MySQL from 5.7.44 to 8.0.28 and I end up needing to remove a stored procedure named `mysql.flush_rewrite_rules` but I have no permissions to do so. Therefor I am blocked and...
0
answers
0
votes
5
views
asked 23 minutes agolg...
I'm trying to upgrade the mysql instance from 5.7.44 to 8 and up. I have a smaller scale "test" db with the same configuration as my production db. Last week I tried and managed to get the test side...
0
answers
0
votes
9
views
asked an hour agolg...
Timestream table can have magnetic store writes enabled and it can take up to 6 hours for the data to become readable if we do write into magnetic store.
I am wondering if writing new records into...
0
answers
0
votes
16
views
asked 3 hours agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
0
answers
0
votes
24
views
asked 9 hours agolg...
Is it technically possible and secure to establish an ODBC connection to the RDS that is in the public subnet over the internet? I couldn't find AWS documentation regarding this question, so I would...
3
answers
0
votes
54
views
asked 11 hours agolg...
I have a client who has observed the following symptoms:
What could be the reason behind the intermittent variations in replication lag observed by a customer utilizing RDS Oracle with a read replica...
1
answers
0
votes
31
views
asked 14 hours agolg...
Hi AWS community,
Our team is currently in the process of upgrading the PostgreSQL engine from version 12 to version 16 on AWS RDS. To ensure a seamless migration with zero downtime, we've opted for...
0
answers
0
votes
55
views
asked 17 hours agolg...
I hope this is a suitable place to post this.
I believe there is a small bug in the feedback messages given by the QLDB PartiQL Query Editor.
See below for an example.
The values for latency, I/O...
0
answers
0
votes
46
views
asked 17 hours agolg...
I've attempted to connect multiple ways through multiple tools. According to the [AWS Aurora documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/database-authentication.html),...
1
answers
0
votes
39
views
asked 17 hours agolg...
I'm working on a feature to archive old data from our Aurora Postgres database to S3 using the `aws_s3` extension. This operation takes 20-30 minutes, and sometimes my client gets disconnected and...
0
answers
0
votes
28
views
asked a day agolg...
I can access the RDS by ssh-ing into the EC2 instance, and passing the url and password to psql.
When I try to access the RDS via the docker container running on the EC2 using the same url and...
1
answers
0
votes
58
views
asked a day agolg...
I'm doing a test migration (Oracle to Postgres) of a single table (9K rows, 0.01GB, has 1 BLOB field) to prove that it works.
But it becomes stuck without further events for 1h+ .
Replication type:...
2
answers
0
votes
51
views
asked a day agolg...