Current : Master1 - Standby1 (Streaming Replication)
Future : Master1 - Standby1 - Standby2 (For ETL, New VM)
Hi. We're using streaming replication now. I'm new with PostgreSQL. I want to know If I add one more standby server, Is it possible to use that server for ETL? I mean I'm gonna pause streaming in midnight for ETL in Standby2 and After ETL finished I'm gonna resume streaming. I have no idea how long ETL takes. I found the content in the manual. WAL file will be received even though streaming stopped. But there's no more detail.
Question : If the Pause takes too long in standby2, Streaming replication could have a problem with Master1 and Standby1? I have to make sure there's no effect in our production system, though.
Question : If I resume streaming replication, Replication could be done automatically?
Question : Is there any best way to Make Data warehouse in PostgreSQL? I spend hours googling but I couldn't find documents what I really want.
Thank you:)