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.
Hi AWS community,
Our team is currently in the process of upgrading the PostgreSQL engine from version 12 to version 16 on AWS RDS. To ensure a seamless migration with zero downtime, we've opted for...
0
answers
0
votes
26
views
asked 2 hours agolg...
I've attempted to connect multiple ways through multiple tools. According to the [AWS Aurora documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/database-authentication.html),...
0
answers
0
votes
26
views
asked 2 hours 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
96
views
asked 6 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
41
views
asked 7 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
50
views
asked 8 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
77
views
asked 12 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
71
views
asked 14 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
3
votes
94
views
asked 17 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
225
views
asked 22 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...
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
72
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
96
views
asked 3 months agolg...