I've gotten a case that I need to replicate data from Cloud SQL for PostgreSQL to an external on-premise PostgreSQL DB. I've read the document and found that Cloud SQL for PostgreSQL does not support external replication yet. I've tried to search for a solution on the internet but was unlucky to find one. Does anyone have an idea on how to do this? 3rd party solution is also welcome.
The functionality is indeed not yet supported. Until it is, one workaround would be to schedule exports at regular intervals to a storage solution, and then import the dumps to the on-premise database. Here is how:
1- Create a Cloud Storage bucket into which the export dumps will be stored
4- Use your desired method for importing the regular dumps to the on-premise database