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.
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
854
views
asked 10 months agolg...
RDS Proxy metricslg...
Does the metric `QueryResponseLatency` of the RDS proxy include `DatabaseConnectionsBorrowLatency` and `QueryDatabaseResponseLatency`?
2
answers
0
votes
410
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
1222
views
asked 10 months agolg...
Is it possible to log queries and their IOPS consumption for cost optimization purposes?
2
answers
0
votes
563
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
139
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
109
views
asked 10 months agolg...
I have a pglogical logical replication set from on-prem Postgres 12 to AWS RDS Postgres 12 (this replication has been set up long time ago and was working fine).
I have deployed some breaking DDL...
1
answers
0
votes
573
views
asked 10 months agolg...
I've been successfully running DMS migrations into a Postgres 14 target for some months now. Seeing that DMS 3.5.1 now supports Postgres 15.x, I created a Postgres 15.3 database and tried to setup DMS...
5
answers
0
votes
1899
views
asked 10 months agolg...
I want to create an postgres instance on ecs for test purpose.
Could I access the postgres by ALB.
1
answers
1
votes
549
views
asked 10 months agolg...
Hello Gents,
I have a Postgresql database on RDS using Free Tier, last month I realized that DB Storage and Time passed 90 % of my free tier quotas, I did some searching and find the solution to...
1
answers
0
votes
220
views
asked 10 months agolg...
I created flows from Google Analytics4 to Amazon RDS for PostgreSQL, after a couple of days the incremental transfer option under 'Flow trigger' -> 'Run flow on schedule' became gray.
The existing...
0
answers
0
votes
77
views
asked 10 months agolg...