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'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
344
views
asked 9 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
454
views
asked 9 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
457
views
asked 9 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
1143
views
asked 9 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
97
views
asked 9 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
111
views
asked 9 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
378
views
asked 9 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
907
views
asked 9 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
386
views
asked 9 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
449
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
303
views
asked 9 months agolg...
We have approx. 20-30 EC2 machines which users use on regular basis; however, from last 30 minutes, no user is able to connect to any of the EC2 machines and also to RDS. Not sure what happened. Error...
4
answers
0
votes
249
views
asked 9 months agolg...