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.
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
183
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
777
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
399
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
224
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
568
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
310
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
415
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
371
views
asked 8 months agolg...
I had a AWS Glue connection and job working fine with Postgres RDS.
Now after following https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html article I upgraded my RDS's CA...
3
answers
2
votes
1072
views
asked 8 months agolg...