Read Replica replication - auth networks

27 views
Skip to first unread message

Tibor Tribus

unread,
Nov 19, 2020, 12:24:18 PM11/19/20
to Google Cloud SQL discuss
Hi, I have question about sql replication. I can't find how replications works for authorized networks.

I do have authorized networks on primary DB. After I delete one authorized networks, all others networks are deleted from read replica. After this point no auth networks are replicated. Even when I add manually auth network on Read replica, after redeploy it's deleted.

I would like to be able to have different auth networks on primary DB and read replica, for analytical purposes.

Database version is PostgreSQL 11.
We are using Terraform to provision DBs.

Thank you.

gonzalezwalter

unread,
Nov 22, 2020, 11:53:00 AM11/22/20
to Google Cloud SQL discuss
Hello,

While attempting to replicate your issue, I assigned a authorized network to a Cloud PostgreSQL instance and then created a replica. Afterwards, I assigned a different authorized network to the replica and deleted the authorized network on the original. The results were that the replica kept the new authorized network and the original.  

As you had a different experience can you provide the exact steps you took. As a note if you were to delete and then recreate the replica it would only have authorized network on the original. 
Reply all
Reply to author
Forward
0 new messages