'Is it possible to have a read replicas of azure flexible postgresql server with a subset of data?
Is it possible to replicate a specific subset of data (certain schema,dbs') to a readonly copy of Azure postgres flexible server. Thanks Brian
Solution 1:[1]
From Logical replication and logical decoding in Azure Database for PostgreSQL - Flexible Server
Limitations
Read replicas - Azure Database for PostgreSQL read replicas are not currently supported with flexible servers.
Solution 2:[2]
At the moment this is not possible with azure so we ended up using pglogical replication to copy specific databases over between the regions.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | KarthikBhyresh-MT |
| Solution 2 | b Od |