Pg logical replication

From: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Pg logical replication
Date: 2018-12-11 14:42:43
Message-ID: 45858D83-3300-4308-947E-C44A067480EA@webedia-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
We would like to use temp table on our streaming slaves ( no possible).
So we would like to replace replication streaming by logical replication ( all tables) .
Is possible to create a publication per schema even if there are some constraints between these schema ( check, domains )?
How to handle DDL on schema on the slave ?

Thanks you in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-12-11 15:04:21 Re: Pg logical replication
Previous Message Thomas Kellerer 2018-12-11 14:13:14 Oracle FDW and Postgres yum repository (CentOS 7)