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'm using an Amazon Aurora PostgreSql DB cluster and I am receiving the following error after a failover:
"PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction"
I'm...
1
answers
1
votes
427
views
asked 16 days agolg...
Hi,
I am trying to get oracle_fdw working for PostgreSQL-Aurora to access an on-prem OracleDB following this...
4
answers
0
votes
476
views
asked 19 days 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
244
views
asked 19 days agolg...
I am downsizing my RDS instances, and for example I had a machine with 8GB Ram with 6 GB of free memory and then after I modify this database to a 4GB Ram machine, I could see in the monotoring...
3
answers
0
votes
107
views
asked 20 days agolg...
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...
1
answers
0
votes
102
views
asked 22 days 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
542
views
asked 22 days 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...
2
answers
0
votes
241
views
asked 23 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
539
views
asked 23 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
141
views
asked a month 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
200
views
asked a month 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
146
views
asked a month 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
80
views
asked a month agolg...