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.
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
230
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
184
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
781
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
118
views
asked 7 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
401
views
asked 7 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
225
views
asked 7 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
570
views
asked 7 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
239
views
asked 7 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
255
views
asked 8 months agolg...
Hello,
I've recently re-architected my application, which is written in Ruby on Rails and uses a PostgreSQL 13 database, from a setup where everything was in public networks, as shown in the attached...
2
answers
0
votes
312
views
asked 8 months agolg...
Hi Team,
I need advise on migrating data from one AWS DB running PostgreSQL in AWS to another DB running PostgreSQL also in AWS.
There are thousand's of tables within the DB that is to be migrated...
2
answers
0
votes
416
views
asked 8 months agolg...
Hello AWS Community,
I hope this message finds you well. I am currently facing some challenges during my MySQL to PostgreSQL migration on Amazon RDS. I have followed several steps to set up the...
1
answers
0
votes
374
views
asked 8 months agolg...