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.
RDS Proxy metricslg...
Does the metric `QueryResponseLatency` of the RDS proxy include `DatabaseConnectionsBorrowLatency` and `QueryDatabaseResponseLatency`?
2
answers
0
votes
398
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
135
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
1205
views
asked 10 months agolg...
Is it possible to log queries and their IOPS consumption for cost optimization purposes?
2
answers
0
votes
551
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
137
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
106
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
563
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
1835
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
540
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
212
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
73
views
asked 10 months agolg...
I am using below command to load data from s3 to postgresql database.
SELECT aws_s3.table_import_from_s3 (
'delta.t_etails',
'',
'(FORMAT csv, HEADER true, DELIMITER '','', QUOTE ''~'', ENCODING...
1
answers
0
votes
463
views
asked 10 months agolg...