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'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
79
views
asked 5 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
41
views
asked 5 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
112
views
asked 5 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
69
views
asked 5 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
141
views
asked 6 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
327
views
asked 6 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
71
views
asked 6 days agolg...
I'm going to create Leaderboard using this example as a reference.
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GSI.html
There are two access patterns.
1. Get Top 100
```
{
...
Accepted AnswerAmazon DynamoDB
1
answers
0
votes
55
views
asked 6 days agolg...
I have set up an Aurora serverless v2 cluster from an RDS Postgres instance. The Data API is enabled.
I'm trying to query it to test the connection. I've tried through Query Editor, a third party...
2
answers
0
votes
163
views
asked 6 days agolg...
What are the performance considerations while using the Redshift Federated Queries to access and query data present in Amazon Aurora RDS PostgreSQL database? The Redshift Zero ETL feature is still in...
1
answers
0
votes
118
views
asked 6 days agolg...
Hi, I have multiples postgres database instance on RDS, but, for some reason, out of nowhere, some of them now have no public connection, without any active intervention.
What is weird is that I can...
1
answers
0
votes
93
views
asked 6 days agolg...
Hi,
In Timestream, is it possible to create a table with more than one partition key? It seems like it should be, but the UI does not allow it. In the customer defined partition key section when...
Accepted AnswerAmazon Timestream
2
answers
1
votes
55
views
asked 6 days agolg...