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.
Our database had a multi-az failover on April 14th, and the Event Logs said "The primary host of the RDS Multi-AZ instance is unreachable due to loss of network connectivity." I would like to confirm...
1
answers
0
votes
96
views
asked 2 months 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...
1
answers
3
votes
140
views
asked 2 months agolg...
I would like to use transportable tables to migrate a database from one postgres rds instance to another. I've followed the instructions found...
1
answers
0
votes
213
views
asked 2 months agolg...
Hello,
Will anyone know how to assist with a TLS handshake failed error when trying to establish a connection between DMS and MongoDB Atlas? More details below:
MongoDB Atlas switched to using "SRV"...
2
answers
0
votes
271
views
asked 2 months 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
237
views
asked 2 months agolg...
Operating system- system-update shows "in-progress" from last 2 hours under `Pending maintenance ` under Maintenance & Backup Tab.
And the DB Instance status show as Upgrading from last 2 hours as...
1
answers
0
votes
144
views
asked 2 months agolg...
Am currently running PostgreSQL 15.5. There is an upgrade available to 15.5-R2 which under Release Notes says "Blocked the meta-command execution, for example, \copy, \i, and \lo_export, in psql....
1
answers
0
votes
196
views
asked 2 months agolg...
Hi everyone, our audit verified a case where a read-only user appeared in the log as responsible for executing a DDL command, we performed all the necessary tests and saw that the command executed was...
1
answers
0
votes
214
views
asked 2 months agolg...
Hi folks, I have a ~200GB postgres database on an m6g.xlarge instance that I am trying to migrate to a new instance. The end goal of the migration is to reduce our overprovisioned volume size from...
1
answers
0
votes
187
views
asked 2 months agolg...
Per [the docs here](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ParamValuesRef.html#USER_FormulaVariables), `DBInstanceVCPU` should be supported.
However, I've noted that in the...
1
answers
0
votes
235
views
asked 2 months agolg...
Hello,
how can the logging of RDS Proxy be turned off or at least set to ERROR level instead of INFO?
My RDS Proxy spams my CloudWatch with connecting and disconnecting INFO messages that are not...
1
answers
0
votes
181
views
asked 2 months agolg...
Hi,
I ran the DR test and I managed to restore a new RDS instance using the PITR on the (RDS) Automated backup, however when I inspected the data in the database I only found a very small subset of...
2
answers
0
votes
130
views
asked 2 months agolg...