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,
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
27
views
asked 10 hours 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...
0
answers
0
votes
24
views
asked 19 hours 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
70
views
asked a day 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
87
views
asked 2 days 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
50
views
asked 4 days 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
196
views
asked 6 days 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
63
views
asked 7 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
84
views
asked 11 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
89
views
asked 11 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
82
views
asked 12 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
94
views
asked 13 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
150
views
asked 13 days agolg...