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.
Hello,
I am using performance insights to troubleshoot high CPU(98%) issue on PostgreSQL RDS.
RDS -> Writer Instance -> sessions (Current activity) -> Dimensions -> Top hosts
There I can see Unknown...
0
answers
0
votes
8
views
asked an hour agolg...
Since 11 has reached EOL, our company is planing to **Migrate from 11.17 to 16.2**.
It will be helpful if anyone could suggest us any step by step safer & standard approach to do the...
0
answers
0
votes
23
views
asked 11 hours agolg...
When using AWS DMS, all boolean columns in the CDC are consistently marked as `true` (in parquet files that DMS outputs to S3), regardless of their actual value in the source database.
We are using...
0
answers
0
votes
87
views
asked 10 days 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
134
views
asked 19 days agolg...
I have Pega application on DB2 which has to be migrated to RDS PostgreSQL.
Can I pass Pega SQL queries as text file to SCT for converting to PostgreSQL?
Reference URL will help. Thanks
0
answers
0
votes
74
views
asked 20 days agolg...
We set up a blue/green deployment for our production PostgreSQL RDS during off-peak hours. However, shortly after the creation was completed, I noticed that the data in the Green environment was...
0
answers
0
votes
65
views
asked 21 days agolg...
Hi Team,
We want to setup a replication between 2 PostgreSQL RDS instances using logical replication. The condition we have is that on the master instance, we have around 4 years of data, but on the...
0
answers
0
votes
76
views
asked a month agolg...
Hello,
I have a Redshift database as well as multiple Aurora PostgreSQL clusters. My Aurora PSQL clusters use varying versions of the PSQL engine:
* 15.4
* 14.9
* 14.6
* 13.12
* 13.8
My goal is to...
0
answers
0
votes
230
views
asked a month 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
138
views
asked 2 months agolg...
I have an Aurora PostgreSQL regional cluster database (version 15.5), with one writer instance and two reader instances. This database has a large partitioned table with 97 partitions of varying...
0
answers
0
votes
76
views
asked 3 months agolg...
I am trying out DMS as a proof of concept from postgres RDS to postgres RDS - when migrating a databse containing only 1 table no problem is encountered however when attempting to migrate a larger...
0
answers
1
votes
100
views
asked 3 months agolg...
In a new pipeline we are adding to our product, we are collecting a bunch of data from different sources with something similar to keywords. The collected data is mainly text with associated metadata....
0
answers
0
votes
138
views
asked 3 months agolg...