Re: PostgreSQL replication lag - Suggestions and questions

2021-06-10 Thread Vijaykumar Jain
> My current architecture is: master (AZ1) --> read slave (AZ2) --> hot-standby (AZ2) - They are all using streaming replication. I am not sure of the difference between read replica and a hot standby. At least with later versions hot standby allows read queries. I mean unless you do not want quer

PostgreSQL replication lag - Suggestions and questions

2021-06-09 Thread Lucas
Hi, I have a cluster of PostgreSQL 9.2.21, where there is one master and one slave with streaming replication. I have few points and questions about the replication, and was hopping you guys could share your opinions, suggestions and experiences. > Before I start; Yes! I know... PG 9.2? Really?