- Newest
- Most votes
- Most comments
Based on the description you've provided, it appears you are looking at a hybrid environment that includes both Amazon RDS for PostgreSQL instances and an Amazon Aurora PostgreSQL cluster. Here's an explanation of what you're seeing:
-
The Primary node with PostgreSQL as the Engine is likely an Amazon RDS for PostgreSQL instance. This is your main RDS PostgreSQL database.
-
The Replica with PostgreSQL as the engine is probably a read replica of your primary RDS PostgreSQL instance.
-
The two nodes under the primary which have Aurora PostgreSQL as the engine are most likely part of an Amazon Aurora PostgreSQL cluster. This Aurora cluster appears to be set up as a read replica of your RDS PostgreSQL instance.
This configuration suggests that your environment is in a transition state or has been set up for migration purposes. It's possible that there's an ongoing process to migrate from the RDS PostgreSQL instance to an Aurora PostgreSQL cluster using the Aurora read replica method.
In this setup, the RDS PostgreSQL instance (the primary) is replicating data to both its RDS read replica and the Aurora PostgreSQL cluster. This allows for a smooth transition from RDS to Aurora while maintaining data consistency.
If you need to upgrade the RDS PostgreSQL instance, you should focus on the primary PostgreSQL node and its direct replica. However, given this complex setup, it's crucial to carefully plan any upgrades and consider how they might affect the Aurora cluster. You may want to consult with your database administration team or AWS support to understand the full implications and the best approach for upgrades in this environment.
Sources
Migrating data from an RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora read replica - Amazon Aurora
That environment looks like its half way migrating from a PostGres RDS instance to an Aurora Serverless cluster.
Migrating from an RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster is a multistep procedure. First, you create an Aurora read replica of your source RDS for PostgreSQL DB instance. That starts a replication process from your RDS for PostgreSQL DB instance to a special-purpose DB cluster known as a Replica cluster. The Replica cluster consists solely of an Aurora read replica (a reader instance).
I recommend, you may want to finish off the migration at somepoint
Relevant content
- asked 10 months ago
- asked 10 months ago
