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.
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
238
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
193
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
137
views
asked 2 months agolg...
Seems to be superior to the pg_stat_statements extension:
https://docs.percona.com/pg-stat-monitor/
1
answers
2
votes
205
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
782
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
175
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
326
views
asked 2 months agolg...
I have a scenario where I need to move data from S3 to a Postgres database running on an EC2 instance. All of this is part of cdk app so I'm looking to add this as a step to the current step function....
1
answers
0
votes
286
views
asked 2 months agolg...
Hello
I have created AWS RDS DB Proxy in Terraform to connect through it with our application. We are using ssl root certs for encryption. And everything works fine if connect from app to DB...
4
answers
0
votes
469
views
asked 2 months agolg...
We need a working fulltext search on aurora postgres, so we need to create a custom dictionary.
How can we install/upload the dictionary files to the server.
1
answers
0
votes
209
views
asked 3 months agolg...
When config Grafana Postgres data source; host, user, pwd, etc with AWS RDS credentials i get the error: `pq: no pg_hba.conf entry for host "X.X.X.X", user "xxxx", database "xxxx", no...
2
answers
0
votes
527
views
asked 3 months agolg...
I'm trying to write a script to upgrade an RDS PostgreSQL instance from version x to version y. Since RDS only supports direct upgrades to certain versions, the script uses multiple "hops" to upgrade,...
0
answers
0
votes
147
views
asked 3 months agolg...