Unanswered Questions tagged with 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 implemented a AWS DMS task to replicate RDS PostgreSQL (source) changes to Kinesis Data Streams (target). At the moment, the task is responsible for only replicating a single table, which is a...
0
answers
0
votes
126
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...
I am attempting to upgrade my Aurora Postgres Cluster from 11.18 to 13.9 (only valid upgrade path) and I instantly receive an error notification on the console. The error does not have any details and...
0
answers
0
votes
160
views
asked 7 months agolg...
I'm trying to set up a blue/green upgrade of a PostgreSQL cluster from 11.21 to 15.4. During the process I've had several incompatible parameter issues, which I was able to fix by updating the...
0
answers
0
votes
89
views
asked 7 months agolg...
Hello,
does anyone have insight on Aurora Postgres disk throughput / read throughput? We have been thinking of migrating RDS postgres to Aurora but benchmarking our case produced results that are...
0
answers
0
votes
66
views
asked 8 months agolg...
In my Django application, I'm utilizing AWS RDS PostgreSQL as my database backend. I've encountered an issue when attempting to send a POST request to store data in the database. After a period of...
0
answers
0
votes
143
views
asked 8 months agolg...
MSSQL RDS is migrated to Postgres RDS Aurora using Babelfish.
This migrated db works fine with direct endpoint of RDs Aurora Instance.
But fails to recognize Old MSSQL queries , Stored procedures...
0
answers
0
votes
187
views
asked 8 months agolg...
In Version 15.3 of Aurora PostgreSQL, log_checkpoints is on by default, It was off in Version 14.
There parameter is not visible in the Cluster Parameter Group and it is causing a lot of writing to...
0
answers
0
votes
91
views
asked 8 months agolg...
I am using AWS DMS in which I am migrating the data from Aurora Postgresql DB to Amazon S3. When I perform a full load operation I am getting whole data including LOB columns but when in case of CDC...
0
answers
0
votes
132
views
asked 9 months agolg...
What version are you upgrading from?
9.9 LTS Developer Version
System information (Operating system, Java version, Database provider/version)
AWS ec2 instance, java 11, **Postgresql 10.23**
What’s the...
0
answers
0
votes
101
views
asked 9 months agolg...
From reading this article https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-pinning, it seems like it does.
But from reading this Reddit comment...
0
answers
0
votes
117
views
asked 9 months agolg...
using pgcrypto externsion in psotgres sql, following is the output for below queryies
Query 1:
```
explain analyze (select * from table_name);
```
above query taking time around 900...
0
answers
0
votes
101
views
asked 10 months agolg...