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.
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
259
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
318
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
428
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
398
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
1091
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
89
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
106
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
364
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
841
views
asked 8 months agolg...
Morning all,
So I have a single instance RDS (multi-az) postgres database. We want to migrate over to Aurora for several reasons, and so this is where I am at. Since it's a mult-az, from the...
4
answers
0
votes
356
views
asked 8 months agolg...
I am trying to use AWS DMS to migrate our PostgreSQL to MySQL which are hosted in AWS RDS.
PostgreSQL version = 14.0
MySQL version = 8.0
Below are the steps I followed:
- created a replication...
1
answers
0
votes
433
views
asked 9 months agolg...
Hello there,
Our company is currently migrating PostgreSQL databases from EC2 instances to the AWS RDS service.
We migrated over 24 databases, and everything was okay till Monday.
Since yesterday,...
1
answers
0
votes
288
views
asked 9 months agolg...