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 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
0
votes
28
views
asked 19 hours 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
21
views
asked 2 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
23
views
asked 3 days agolg...
I just jumped into the deep end on this, so please bear with me.
I'm trying to update the PostgrSQL engine on a db as safely as possible, which AWS says means I should use a blue/green deployment. ...
0
answers
0
votes
60
views
asked 6 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
59
views
asked 8 days agolg...
Postgres DB engine: 14.10
After much experiment, I found out that Aurora Postgres Cluster can not access S3 for copying data. For otherwise exactly same setup, a native RDS Postgres instance can...
0
answers
0
votes
76
views
asked 11 days 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
223
views
asked 17 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
130
views
asked a month agolg...
This is a related question for AWS Aurora PostgreSQL: https://repost.aws/questions/QUF12RpagpTey5vszbg4Fm9w/pg-ivm-plugin-for-aurora-postgresql
0
answers
4
votes
421
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
71
views
asked 2 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
93
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
130
views
asked 3 months agolg...