Unanswered 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.
Hi there, I've been playing around with AWS DMS and Aurora PostgreSQL serverless and I've come across a bit of a problem. I've demonstrated it on a table with a composite primary key, but I suspect it...
0
answers
1
votes
187
views
asked 5 days agolg...
Currently I only have "log_min_duration_statement" enabled in the RDS settings. My alert will count how many times the “duration” appears in the logs and thus alert you when the limit is...
0
answers
0
votes
76
views
asked 6 days agolg...
I have exported some data using the `query_export_to_s3` function and it has generated several files in S3 (split by 6GB).
I then imported the same data into another table using the...
0
answers
0
votes
363
views
asked 25 days agolg...
I have an issue with my RDS Proxy on AWS. I've configured a proxy for my PostgreSQL database, which works correctly within my VPC. However, I'm trying to use Amazon AppFlow to access the database...
0
answers
0
votes
567
views
asked a month agolg...
When using AWS DMS, all boolean columns in the CDC are consistently marked as `true` (in parquet files that DMS outputs to S3), regardless of their actual value in the source database.
We are using...
0
answers
0
votes
262
views
asked a month agolg...
Hello AWS Community,
I'm seeking advice regarding a persistent error we're facing with our Aurora PostgreSQL Serverless V2 setup running PostgreSQL 15.5. We are periodically receiving an error...
0
answers
1
votes
160
views
asked 2 months agolg...
I have Pega application on DB2 which has to be migrated to RDS PostgreSQL.
Can I pass Pega SQL queries as text file to SCT for converting to PostgreSQL?
Reference URL will help. Thanks
0
answers
0
votes
90
views
asked 2 months agolg...
We set up a blue/green deployment for our production PostgreSQL RDS during off-peak hours. However, shortly after the creation was completed, I noticed that the data in the Green environment was...
0
answers
0
votes
103
views
asked 2 months agolg...
Hi Team,
We want to setup a replication between 2 PostgreSQL RDS instances using logical replication. The condition we have is that on the master instance, we have around 4 years of data, but on the...
0
answers
0
votes
88
views
asked 2 months agolg...
Hello,
I have a Redshift database as well as multiple Aurora PostgreSQL clusters. My Aurora PSQL clusters use varying versions of the PSQL engine:
* 15.4
* 14.9
* 14.6
* 13.12
* 13.8
My goal is to...
0
answers
0
votes
245
views
asked 2 months agolg...
I'm trying to write a script to upgrade an RDS PostgreSQL instance from version x to version y. Since RDS only supports direct upgrades to certain versions, the script uses multiple "hops" to upgrade,...
0
answers
0
votes
150
views
asked 3 months agolg...
I have an Aurora PostgreSQL regional cluster database (version 15.5), with one writer instance and two reader instances. This database has a large partitioned table with 97 partitions of varying...
0
answers
0
votes
95
views
asked 4 months agolg...