We have created 2 postgresql server in 2 regions. Both have geo redundant backup on.
What are the steps to restore a specific DB on 1 server of the region to the server on the other region.
I only found articles where it mentioned to create an entire new server from the backup of the server of the other region.
Our requirement is to restore a specific DB from 1 region to another. Server in both the region already exits.