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.
I have 2 different Redshift clusters. Each cluster have a PostgreSQL database with the same schema.
I want to do a federated query across these 2 databases in the 2 different Redshift clusters.
Is...
0
answers
0
votes
21
views
asked 2 hours agolg...
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
190
views
asked 6 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
78
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 a month 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
568
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
161
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
104
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...