| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg logical replication |
| Date: | 2018-12-11 15:04:21 |
| Message-ID: | cd52d8f0-951a-89e3-ac8a-e87de6e2229b@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 11/12/18 4:42 μ.μ., Mai Peng wrote:
> 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) .
That's possible, provided all tables have a valid default REPLICA IDENTITY (i.e. PK)
> Is possible to create a publication per schema even if there are some constraints between these schema ( check, domains )?
At the moment, (as of pgsql 11) you cannot specify a schema.
> How to handle DDL on schema on the slave ?
By hand, or by other means, logical replication won't do this for you.
>
> Thanks you in advance
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2018-12-12 11:46:17 | Re: PG Encryption / pg_read_file |
| Previous Message | Mai Peng | 2018-12-11 14:42:43 | Pg logical replication |