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.
I have found a bug when calling Lambda from Postgres RDS. I am using Postgres version 13. I have created a one minute video nailing down the bug:
https://youtu.be/Y1ALUxEwzGk
I am using the following...
3
answers
1
votes
598
views
asked 9 months agolg...
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
118
views
asked 9 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
274
views
asked 9 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
243
views
asked 9 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
239
views
asked 9 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
507
views
asked 9 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
807
views
asked 9 months agolg...
RDS Proxy metricslg...
Does the metric `QueryResponseLatency` of the RDS proxy include `DatabaseConnectionsBorrowLatency` and `QueryDatabaseResponseLatency`?
2
answers
0
votes
393
views
asked 9 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
131
views
asked 9 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
1183
views
asked 9 months agolg...
Is it possible to log queries and their IOPS consumption for cost optimization purposes?
2
answers
0
votes
534
views
asked 9 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
130
views
asked 10 months agolg...