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.
Hi there, I've been playing around with AWS DMS and Aurora PostgreSQL serverless and I've come across a bit of a problem. I've demonstrated it on a table with a composite primary key, but I suspect it...
0
answers
1
votes
190
views
asked 6 days agolg...
![![Enter image description here](/media/postImages/original/IMFS53IpuyTse4k_w1s4c1Fw)
![Enter image description here](/media/postImages/original/IMB8CzPhKYRx6-axpyWWeO1Q)
There are 3 drops in...
1
answers
0
votes
89
views
asked 6 days agolg...
![Enter image description here](/media/postImages/original/IMdQlbBkN6TSaKxgrd6S8AmQ)
Both queries are the same except WHERE entity in (different identifier) as the first step in a CTE.
The entity in...
0
answers
0
votes
80
views
asked 6 days agolg...
Hi,
I'm trying to implement a DR for an Oracle RDS, for testing, we are copying the backups to a different region, I'm creating a PITR but is taking too long to create the new instance, it has been on...
0
answers
0
votes
89
views
asked 6 days agolg...
Hey all, I have this code and I am not seeing what I am doing wrong.
I am creating an RDS in CDK :
```
const secret = this.createDatabaseInstanceSecret(appName, props.deployEnv,...
1
answers
0
votes
88
views
asked 6 days agolg...
I just noticed that the EU-ExtendedSupport:Yr1-Yr2:MySQL5.7 billing on rds. however we didn't recieve a notification email informing us of this change.
We receive other emails however, for example...
0
answers
0
votes
53
views
asked 6 days agolg...
This blog covers the best practices to migrate an on-premises SAP ASE (Sybase) database to an Aurora PostgreSQL database using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service...
1
answers
0
votes
109
views
asked 6 days agolg...
I want certain users in the Cognito user pool to have permissions to access the database. For this I created a group and assigned it a role to access the database. I created an identity pool by...
1
answers
0
votes
181
views
asked 6 days agolg...
Currently I only have "log_min_duration_statement" enabled in the RDS settings. My alert will count how many times the “duration” appears in the logs and thus alert you when the limit is...
0
answers
0
votes
78
views
asked 6 days agolg...
Hi All,
is it possible item level recovery in document db, i don't see options in console.
we have only taking backup and restore cluster , instance from snapshot.
Could someone please help on this,...
1
answers
0
votes
41
views
asked 6 days agolg...
I want to restore an IBM DB2 backup image (**SAMPLE.0.db2inst1.DBPART000.20230723133415.001 **) to an AWS RDS IBM DB2 instance. Upon researching, I found that we can use the stored procedure...
1
answers
0
votes
105
views
asked 7 days agolg...
This is on their website: Can use a CloudWatch Logs subscription to stream log data in near real time to an Amazon OpenSearch Service cluster. Does it mean it that we can stream log data to OpenSearch...
1
answers
0
votes
200
views
asked 7 days agolg...