Unanswered Questions tagged with Amazon Aurora
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.
Hello,
Its db.r7g.8xlarge aurora postgres 32VCPU, 256GB RAM instance. PG version 15.4.
A non-partitioned table having ~4.8 billion rows in it and is having data size as ~1.4TB, row size as ~313 bytes...
0
answers
0
votes
240
views
asked 4 months agolg...
I used SCT to convert the DDL below from DB2 to Aurora PostGreSQL.
DB2:
CREATE SEQUENCE XX_SCHEMA.SEQ_NO AS DECIMAL(9) START WITH 1 INCREMENT BY 1 MAXVALUE 9999999999 CYCLE;
then I got this DDL as...
0
answers
0
votes
176
views
asked 5 months agolg...
I have a data pipeline built in Redshift Serverless, with some final tables being the result. We are also running a web app that I have set up an Aurora Serverless Postgres DB, to run from. The idea...
0
answers
0
votes
128
views
asked 5 months agolg...
Hi there.
We have an Aurora PostgreSQL DB running with several reader instances. We also got a custom Jenkins job to launch and terminate the read replicas based on our needs.
What I noticed is,...
0
answers
0
votes
95
views
asked 5 months agolg...
The situation is I have a RDS cluster running with RDS instance in it. Sometimes when we update the stack for RDS cluster it deletes the physical resource and re creates it. But as the RDS instance is...
0
answers
0
votes
115
views
asked 5 months agolg...
Hi.
I saw on the PSQL official docs that it is possible to select a certain shutdown mode, something like SIGTERM OR SIGINT based on the use...
0
answers
0
votes
94
views
asked 5 months agolg...
we are using this request VTL code.
{
"version": "2018-05-29",
"statements": [
"INSERT INTO company1.companies(name) VALUES (:name)",
"SELECT LAST_INSERT_ID() AS id, name FROM...
0
answers
0
votes
464
views
asked 5 months agolg...
Hello AWS Community,
I am experiencing a challenging issue with my AWS RDS Serverless V1 instance and seeking guidance. For about a month now, I've noticed a significant and unexplained increase in...
0
answers
0
votes
182
views
asked 6 months agolg...
Hello, I am trying to use materialized views in Redshift, where I have a Zero-ETL integration configured from Aurora MySQL to Redshift. Since the destination Redshift database is completely read-only...
0
answers
0
votes
154
views
asked 6 months agolg...
I created a dummy aurora database (serverless,engine - 8.0.mysql_aurora.3.02.2, multi-az no, encryption enabled, default KMS key, capacity type - Provisioned: single master, password authentication...
0
answers
1
votes
134
views
asked 7 months agolg...
Is it possible to run a Glue Crawler on an Aurora Postgres 15 Serverless v2 database?
Following this issue here:
https://github.com/awslabs/aws-advanced-jdbc-wrapper/issues/653
For the last few...
0
answers
0
votes
176
views
asked 7 months agolg...
Babelfish upgrade errors from Aurora 13.8 with Babelfish 1.4.0 to Aurora 14.6 with Babelfish 2.3.0lg...
Customer is receiving these errors while attempting to upgrade their database - this is an in-place upgrade where everything is currently working under version Aurora 13.8 with Babelfish 1.4.0
**Some...
0
answers
0
votes
138
views
asked 7 months agolg...