postgres features replication streaming (default, when data transfer from master WAL to slaves), slave is read only logical (e.g. slony и pglogical), allows replicate particular DB or tables to one slave, and another