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
773
views
asked 9 months agolg...
RDS Proxy metricslg...
Does the metric `QueryResponseLatency` of the RDS proxy include `DatabaseConnectionsBorrowLatency` and `QueryDatabaseResponseLatency`?
2
answers
0
votes
381
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
130
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
1166
views
asked 9 months agolg...
Is it possible to log queries and their IOPS consumption for cost optimization purposes?
2
answers
0
votes
515
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 9 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
100
views
asked 9 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
542
views
asked 9 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
1725
views
asked 9 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
519
views
asked 9 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
204
views
asked 9 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
68
views
asked 9 months agolg...