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 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
234
views
asked a month 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
135
views
asked a month 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
190
views
asked a month 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
208
views
asked a month 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
178
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
225
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
158
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
123
views
asked 2 months agolg...
Seems to be superior to the pg_stat_statements extension:
https://docs.percona.com/pg-stat-monitor/
1
answers
1
votes
185
views
asked 2 months agolg...
Hi!
I have an ubuntu lightsail server that is running a node express app and a postgres server. These were not from a template, I set these up myself, and the database is running in a docker...
1
answers
0
votes
250
views
asked 2 months agolg...
I have an RDS PostgreSQL instance that I would like to keep in the Free Tier. However, after a month with minimal data (6 tables with no data and one table with 5 rows and 4 columns of varchars and...
2
answers
0
votes
165
views
asked 2 months agolg...
What is the correct way to handle Postgres logical replication with DMS CDC after Postgres major update?
Found out that RDS requires removal of logical replication slots before Postgres major version...
1
answers
0
votes
302
views
asked 2 months agolg...