Streaming Replication in postgres between local server and Amazon RDS

0

Hello! I would like to know if it is possible to have my local server as Principal in postgres and have a read replica in Amazon RDS? Or if to do this I need to establish an EC2 instance and not use Amazon RDS

1 個回答
-1

Yes, it is possible to have your local server act as the primary instance (Principal) in a PostgreSQL replication setup and have a read replica in Amazon RDS. However, a PostgreSQL streaming replication would need to be built up between your local server and the Amazon RDS instance in order to accomplish this. You must configure the primary server (your local server) to transmit its WAL (Write-Ahead Log) files to the RDS instance in order to set up streaming replication. It's crucial to keep in mind that in some situations, replicating to an Amazon RDS read replica instead of using your local server as the main instance may not be the best course of action. Consider using Amazon RDS Multi-AZ which is made especially for high-availability and scaling, if you need high availability or you need to scale your database horizontally. Also, note that PostgreSQL streaming replication setup and management can be challenging and requires careful configuration and monitoring.

AWS
已回答 1 年前
  • But there is no parameter's in the parameter group for streaming replication. And also there is no documentations and references available in the internet can you help me with streaming replication in rds

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南