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 have an issue with my RDS Proxy on AWS. I've configured a proxy for my PostgreSQL database, which works correctly within my VPC. However, I'm trying to use Amazon AppFlow to access the database...
0
answers
0
votes
556
views
asked 22 days agolg...
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...
1
answers
0
votes
602
views
asked 25 days 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...
1
answers
0
votes
792
views
asked 25 days agolg...
I can't connect to RDS using TLS. Initially, the issue is probably with the self-signed cert - using "rejectunauthorized: false" works, but I don't want to do that. Then I found out we can pass...
1
answers
0
votes
628
views
asked a month agolg...
I have a database in Postgress and I use RDS. My database had the standard_conforming_strings property turned off, but I need it to be turned on, I configured it in RDS so that the property is turned...
1
answers
0
votes
664
views
asked a month agolg...
I'm using db version engine 13.10 and trying to create an instance with aurora serverless postgresql complaint, but get an error =>
```
creating RDS cluster: The engine version that you specified...
1
answers
0
votes
727
views
asked a month agolg...
Hi!
We've been trying to set up a pub/sub on RDS postgresql and it is failing with an error we were not able to understand.
Publisher is a Aurora postgresql 16.1 database, subscriber is also a...
1
answers
0
votes
918
views
asked a month agolg...
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
442
views
asked a month 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
783
views
asked a month 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
252
views
asked a month 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
129
views
asked a month 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
112
views
asked a month agolg...