Hello,
I am pretty new to Postgres and I have been reading about streaming
replication and point in time recovery which is very interesting to me.
What is not clear to me is: let's say I have a cluster of 1 primary and 2
slaves Postgres 9.5 which have archive_mode on. Streaming replication is
working fine. If for instance, i drop by mistake one table, and i need to
do a restore to a point before the time the table was dropped, will I need
to do the recovery only on the primary postgres server? How will the slaves
behave during the recovery process of the primary?
Please let me know.
Thanks and Best Regards,
Lan Pham