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 am using the "RDS export snapshot to S3" feature to extract some tables from our Postgres RDS cluster.
The largest table in the export has
* 12 billion rows
* 35 columns
* 3TB in Postgres (not...
1
answers
0
votes
627
views
asked 7 months agolg...
We are currently in the process of migrating a Postgresql database from RDS to an S3 data lake. During our data migration, we noticed an important aspect related to transaction order preservation that...
1
answers
0
votes
665
views
asked 7 months agolg...
I'm trying to use the `aws_s3.table_import_from_s3` functionality and believe I have set everything up correctly according to:...
1
answers
0
votes
567
views
asked 7 months agolg...
Now and then I experience a performance/stability problem on our postgres RDS, which seems to be caused by a query from the ***rdsadmin ***user, on the ***rdsadmin ***database.
The query in question...
3
answers
0
votes
751
views
asked 7 months agolg...
Hello,
I'm trying to modify my RDS PostgreSQL instance class from "db.t3.2xlarge" to "db.m5.2xlarge".
I make the change using the portal and check the option to apply immediately. The status is shown...
1
answers
0
votes
166
views
asked 7 months agolg...
In Version 15.3 of Aurora PostgreSQL, log_checkpoints is on by default, It was off in Version 14.
There parameter is not visible in the Cluster Parameter Group and it is causing a lot of writing to...
0
answers
0
votes
79
views
asked 7 months agolg...
Hello,
I'm currently using AWS RDS for PostgreSQL and I've encountered an issue with storage usage. My RDS instance is allocated 20 GiB of storage. However, when I check the size of my database using...
1
answers
0
votes
238
views
asked 7 months agolg...
We have a RDS instance which is stuck in rebooting, nothing seems to help. Can someone advise on how to force reboot a RDS instance?
I can't connect to it, (too many clients). It's postgres...
2
answers
0
votes
186
views
asked 7 months agolg...
Hi, I have some RDS but i want to import them into terraform, so they can be easier to manage, i saw that there is an import command but I'm not sure if using this will be the best approach because if...
2
answers
0
votes
805
views
asked 7 months agolg...
I am using AWS DMS in which I am migrating the data from Aurora Postgresql DB to Amazon S3. When I perform a full load operation I am getting whole data including LOB columns but when in case of CDC...
0
answers
0
votes
120
views
asked 8 months agolg...
I am working on POC to migrate from Debezium to AWS DMS for PostgreSQL. PostgreSQL as Source and Kafka as Destination (AWS MSK). In Debezium i used to see before and after image for updates, but in...
2
answers
0
votes
419
views
asked 8 months agolg...
Hello AWS Community,
I'm encountering a connectivity problem with my RDS PostgreSQL instances. These instances have been running for years without issues, but now I'm experiencing timeouts when...
1
answers
0
votes
231
views
asked 8 months agolg...