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.
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
1077
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
360
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
825
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
347
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
427
views
asked 8 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
285
views
asked 8 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
238
views
asked 8 months agolg...
using pgcrypto externsion in psotgres sql, following is the output for below queryies
Query 1:
```
explain analyze (select * from table_name);
```
above query taking time around 900...
0
answers
0
votes
95
views
asked 8 months agolg...
Hi there.
I noticed that my Aurora PSQL reader DBs are still getting calls even tho they are getting removed.
AFAIK The RDS DB should cut off the reader dbs if they are in a removal state, and...
0
answers
0
votes
123
views
asked 8 months agolg...
I have posted a clear bug here:
https://repost.aws/en/questions/QUXKt7jDIvTMi4SyW2jTKgbg
I even created a narrated youtube video showing and explaining the bug.
I got two answers, but both are...
2
answers
0
votes
249
views
asked 8 months agolg...