Read Replica replication - auth networks

瀏覽次數:27 次
跳到第一則未讀訊息

Tibor Tribus

未讀,
2020年11月19日 中午12:24:182020/11/19
收件者: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

未讀,
2020年11月22日 上午11:53:002020/11/22
收件者: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. 
回覆所有人
回覆作者
轉寄
0 則新訊息