pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Pg logical replication 2+ messages / 2 participants [nested] [flat]
* Pg logical replication @ 2018-12-11 14:42 Mai Peng <maily.peng@webedia-group.com> 0 siblings, 1 reply; 2+ messages in thread From: Mai Peng @ 2018-12-11 14:42 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Pg logical replication @ 2018-12-11 15:04 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Mai Peng <maily.peng@webedia-group.com> 0 siblings, 0 replies; 2+ messages in thread From: Achilleas Mantzios @ 2018-12-11 15:04 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-12-11 15:04 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-12-11 14:42 Pg logical replication Mai Peng <maily.peng@webedia-group.com> 2018-12-11 15:04 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox