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.
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
835
views
asked 8 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
177
views
asked 8 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
88
views
asked 8 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
249
views
asked 8 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
202
views
asked 8 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
864
views
asked 8 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
128
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
449
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
245
views
asked 8 months agolg...
I've created a dedicated IAR role with all the necessary policies to access the redshift and assigned it to my lambda. And also added tags "RedshiftDbRoles". I created a role in the workbench and...
1
answers
0
votes
621
views
asked 8 months agolg...
RDS instance class m6i.2xlarge, the IOPs burst max is 40k, what happens if I'm hitting 35kIOPS?lg...
The documentation is basically non-existent except for a single line saying that the instance can only sustain 40kps 30 min at least once in any 24 hour period (not 100% sure what that means),
What...
3
answers
0
votes
262
views
asked 8 months agolg...
Upon trying `CREATE EXTENSION postgis_sfcgal;`, I got the following error:
"ERROR: Could not open extension control file "/rdsdbbin/postgres-15.4.R1/share/extension/postgis_sfcgal.control": No such...
1
answers
1
votes
285
views
asked 9 months agolg...