Questions tagged with 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 All,
We are migrating the databases to RDS instance where on-premises configured with Alway on. we suggested to configure the Multi-AZ for production servers but Single-AZ is providing 99% SLA and...
1
answers
0
votes
186
views
asked 2 months agolg...
Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to ODBC provider ODBC general error., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HY000...
1
answers
0
votes
289
views
asked 2 months agolg...
Which is the AWS API to use for retrieving data about oracle version if I've already found with DescribeDBInstances the engine version:
Engine Version = 19.0.0.0.ru-2022-10.rur-2022-10.r1
2
answers
0
votes
325
views
asked 2 months agolg...
I am trying to fetch 0.5 million records at once using API->lambda. I am executing this using nodejs and while fetching records programmatically using SQL query my API times out as it redshift...
1
answers
0
votes
387
views
asked 2 months agolg...
Hello All!
Would like to Importing data from Amazon S3 into an RDS for PostgreSQL DB instance, but something is wrong from my side:
ERROR: HTTP -1. curlCode: 28, Timeout was reached
CONTEXT: SQL...
2
answers
0
votes
390
views
asked 2 months agolg...
In Amazon Redshift, the general syntax for creating a procedure is as follows:
```
CREATE [ OR REPLACE ] PROCEDURE sp_procedure_name
( [ [ argname ] [ argmode ] argtype [, ...] ] )
[ NONATOMIC...
2
answers
0
votes
331
views
asked 2 months agolg...
We have some Timestream tables of what I think you could call "metadata" to help us correspond data with devices, customers, etc. Here is an example of a table used to track our hardware...
1
answers
0
votes
225
views
asked 2 months agolg...
I am restoring a native on premise backup from a client into our AWS RDS SQL Server instance. In order to verify the TDE certificate was installed correctly, I attempted the restore without the...
2
answers
0
votes
278
views
asked 2 months agolg...
## Summary
- AWS released new data plane APIs for the Neptune Graph Database engine, in February 2024.
- The data plane APIs, such as **GetEngineStatus**, do not contain any input parameters to...
1
answers
0
votes
211
views
asked 2 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
434
views
asked 2 months agolg...
We are migrating from Redshift to Redshift Serverless to lower costs. I would like to have ongoing replication from RS to RS Serverless so that they are in sync and we can do blue/green rollout by...
2
answers
0
votes
533
views
asked 2 months agolg...
I moved my RDS to a private subnet. But now I cannot connect to the DB using pgadmin locally. What is the best practice to manage a RDS?
2
answers
0
votes
345
views
asked 2 months agolg...