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.
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
42
views
asked 2 days 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
89
views
asked 2 days 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
61
views
asked 2 days 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
65
views
asked 3 days 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
53
views
asked 3 days 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
62
views
asked 3 days 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...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
35
views
asked 3 days 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...
2
answers
0
votes
104
views
asked 3 days 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
65
views
asked 3 days agolg...
I've been attempting to do an Aurora 2 to 3 in place upgrade on our database cluster and it refuses because of a routinesSyntaxCheck failure on some of our custom routines in our DB. There are indeed...
1
answers
0
votes
100
views
asked 3 days agolg...
I am reading multiple files from S3 and writing the output to Redshift DB. Below is my code to read all the files from a S3 location (s3://abc/oms/YFS_CATEGORY_ITEM/)
```
yfs_category_item_df =...
2
answers
0
votes
249
views
asked 3 days agolg...
I want to try serverless database , preferably relational database based on mysql in aws. I am familiar with the concept of relational database. I'm interested in trying out serverless infrastructure...
1
answers
0
votes
60
views
asked 3 days agolg...