cancel
Showing results for 
Search instead for 
Did you mean: 

postgres read replicas

SOLVED
Silver Adventurer

postgres read replicas

looking for info on setting up read replicas for postgres.  what is EDBs solution for read replicas for postgres servers.

documentation links would be great.

 

 

regards

 

matt

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: postgres read replicas

Hi @MattGorham,

 

EFM is for the high availability, if you want it with one standby, then you can have one master, one standby and third as witness node.

 

If you don't want the high availability, then no need of EFM, however, its better to have it for the failover scenarios.

 

The link shared earlier for streaming replication was from EFM documentation, you can refer below link as well :

 

https://info.enterprisedb.com/rs/069-ALB-339/images/Tutorial_Configuring_EDB_Postgres_Advanced_Serve...

 

Regards,

Sudhir

View solution in original post

3 REPLIES 3
EDB Team Member

Re: postgres read replicas

Hi Matt,

 

Irrespective of the platforms, postgres or EPAS is been installed, the Replica Servers are in Read-Only Mode.
Except the Warm Standby, where it acts just like a DR Machine, available on other Data Centre, which when required acts as a Failover option.
EPAS has more of Oracle features.

 

Coming on to your query, on the EDB Documentation, you can go through the below links.

 

Setting Up Read Replica

https://www.enterprisedb.com/edb-docs/d/edb-postgres-failover-manager/user-guides/user-guide/3.5/EDB...


If you would like to have a single Master and multiple Slave Servers, then EDB Replication Server is the option

https://www.enterprisedb.com/edb-docs/d/edb-postgres-replication-server/user-guides/user-guide/6.2/t...

Silver Adventurer

Re: postgres read replicas

If i only setup one read replica for postgre do i need EFM?

Highlighted
EDB Team Member

Re: postgres read replicas

Hi @MattGorham,

 

EFM is for the high availability, if you want it with one standby, then you can have one master, one standby and third as witness node.

 

If you don't want the high availability, then no need of EFM, however, its better to have it for the failover scenarios.

 

The link shared earlier for streaming replication was from EFM documentation, you can refer below link as well :

 

https://info.enterprisedb.com/rs/069-ALB-339/images/Tutorial_Configuring_EDB_Postgres_Advanced_Serve...

 

Regards,

Sudhir

View solution in original post