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
56
views
asked a day 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),...
1
answers
0
votes
47
views
asked a day agolg...
I have set up an Aurora serverless v2 cluster from an RDS Postgres instance. The Data API is enabled.
I'm trying to query it to test the connection. I've tried through Query Editor, a third party...
1
answers
0
votes
111
views
asked 2 days agolg...
What are the performance considerations while using the Redshift Federated Queries to access and query data present in Amazon Aurora RDS PostgreSQL database? The Redshift Zero ETL feature is still in...
1
answers
0
votes
50
views
asked 2 days agolg...
When trying to create a DB instance with Terraform, I'm getting the following error:
> Creating RDS DB Instance (xxxxx): InvalidParameterCombination: RDS does not support creating a DB instance with...
1
answers
0
votes
76
views
asked 6 days agolg...
I’m planning on using Aurora RDS as my service database and I’d be versioning every record I store in the DB. Is there any managed or reliable way to do asynchronous CDC from the DB and store each...
1
answers
0
votes
83
views
asked 7 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
103
views
asked 7 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
45
views
asked 8 days agolg...
Any rough time taken to migrate zOS DB2 to RDS PostgreSQL?
DB2 db size is 50GB, this is only for the actual data migration.
Assuming JDBC connectivity is setup, schema converted, all codes are...
1
answers
0
votes
417
views
asked 9 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
53
views
asked 9 days agolg...
I recently completed a migration using AWS Database Migration Service (DMS) from a source MSSQL DB on RDS to a target PostgreSQL DB on RDS. The full load process completed successfully, but I noticed...
1
answers
0
votes
201
views
asked 12 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
79
views
asked 13 days agolg...