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 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
219
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
552
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
233
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
246
views
asked 7 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
295
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
404
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
351
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
1046
views
asked 8 months agolg...
What version are you upgrading from?
9.9 LTS Developer Version
System information (Operating system, Java version, Database provider/version)
AWS ec2 instance, java 11, **Postgresql 10.23**
What’s the...
0
answers
0
votes
86
views
asked 8 months agolg...
From reading this article https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-pinning, it seems like it does.
But from reading this Reddit comment...
0
answers
0
votes
104
views
asked 8 months agolg...
Hello,
I'm currently using RDS Postgres (Postgres v14 if it matters) and I've hit an issue with corrupted content of pg_catalog tables (pg_class in this case) rendering the DB mostly unusable. I'm...
1
answers
0
votes
351
views
asked 8 months agolg...
Looking for a solution to create an alert for blocking locks in Aurora Postgres or RDS postgres. Has anyone done this and how did you accomplish this?
Thanks!
Jeremy
2
answers
0
votes
797
views
asked 8 months agolg...