Unanswered Questions tagged with Aurora PostgreSQL
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 have a writer instance of a global Aurora Cluster in us-east-1 (N. Virginia) and want to replicate it to a read replica in eu-west-2 (London).
When I measure AuroraReplicaLag, it is in the range of...
0
answers
0
votes
15
views
asked 3 hours 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...
0
answers
0
votes
28
views
asked a day agolg...
Hello AWS Community,
I'm seeking advice regarding a persistent error we're facing with our Aurora PostgreSQL Serverless V2 setup running PostgreSQL 15.5. We are periodically receiving an error...
0
answers
1
votes
103
views
asked 7 days agolg...
I'm trying to write a script to upgrade an RDS PostgreSQL instance from version x to version y. Since RDS only supports direct upgrades to certain versions, the script uses multiple "hops" to upgrade,...
0
answers
0
votes
132
views
asked a month agolg...
After upgrading an Aurora PostgreSQL cluster from 11.21 to 16.1 using a blue-green deployment, we're seeing a bunch of log statements that don't make sense.
For example, after rebooting the writer...
0
answers
1
votes
89
views
asked 3 months agolg...
I source
resource-arn
database &
secret-arn
via instance & secret info for Aurora PostGreSQL Serverless v2, yet invalid cluster is all I get.
0
answers
0
votes
47
views
asked 3 months agolg...
Hey guys. I have the following issues.
During normal operation and after initial load, once a day, pglogical crashes on the destination side, which is RDS aurora PGSQL 14.8 using pglogical....
0
answers
0
votes
343
views
asked 3 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
151
views
asked 3 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
106
views
asked 4 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
77
views
asked 4 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
77
views
asked 4 months agolg...
I'm trying to use the new Aurora resolver tools in Appsync, but it seems that the select utility function is incomplete.
It appears that there is not a supported operator for IN LIST, so my backup...
0
answers
0
votes
74
views
asked 4 months agolg...