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.
Subject: Attempting export to s3 on RDS Postgres 13.10 always results in error "credentials stored with the database cluster can’t be accessed"
I have a production PostgreSQL RDS instance that has...
0
answers
0
votes
122
views
asked 10 months agolg...
Hello
We needed to update from Postgres 10.21 (t2.medium instance) to 14.7 (t3.medium instance). When we made that we found that most of our queries execute extremely slowly or they stuck and do not...
2
answers
0
votes
290
views
asked 10 months agolg...
Hello,
I've setup Athena to query my PostgreSQL database and it works fine. My question is whether it leverages the existing indexes in my tables for improved performance?
2
answers
1
votes
253
views
asked 10 months agolg...
Everytime I visit the Configuration page for my eb environment I get the following error:
```
Invalid option value: '12.9' (Namespace: 'aws:rds:dbinstance', OptionName: 'DBEngineVersion'): Engine...
1
answers
0
votes
251
views
asked 10 months agolg...
I noticed that the rds_replication role in my RDS Postgres DB doesn't actually seem to have the replication role set on them. Is this a bug?
```
=> SELECT rolname, rolreplication FROM pg_roles WHERE...
2
answers
0
votes
528
views
asked 10 months agolg...
Recently had to terminate an SQL query "update cron.job_run_details" that was running indefintely on our RDS db, using SELECT pg_terminate_backend(<jobid>);
Since then, no cron jobs are running. I've...
2
answers
0
votes
877
views
asked 10 months agolg...
RDS Proxy metricslg...
Does the metric `QueryResponseLatency` of the RDS proxy include `DatabaseConnectionsBorrowLatency` and `QueryDatabaseResponseLatency`?
2
answers
0
votes
420
views
asked 10 months agolg...
I have setup a CDC replication task using AWS Database Migration Service (DMS) capturing changes from a Postgres Database and writing them into Kinesis.
This generally works fine but the DMS task...
0
answers
0
votes
138
views
asked 10 months agolg...
Let's say I want to run a data warehouse on an EC2 instance.
It is PostgreSQL-based.
The reason we cannot use RDS, is because it does not support the extensions that we require.
What would be the...
1
answers
0
votes
1247
views
asked 10 months agolg...
Is it possible to log queries and their IOPS consumption for cost optimization purposes?
2
answers
0
votes
579
views
asked 10 months agolg...
[This document](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion.Process) indicates that PostGIS needs to be...
0
answers
0
votes
140
views
asked 10 months agolg...
Hey, i have changed the dynamic parameter value(work_mem, max_parallel_workers_per_gather) but still when running command SHOW ALL; it's showing the old value only. why is it so?
And also when I am...
0
answers
0
votes
110
views
asked 10 months agolg...