Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- CREATE EXTENSION IF NOT EXISTS postgis;
- CREATE EXTENSION IF NOT EXISTS ltree;
- CREATE EXTENSION IF NOT EXISTS intarray;
- CREATE EXTENSION IF NOT EXISTS hstore;
- CREATE EXTENSION IF NOT EXISTS unaccent;
- CREATE EXTENSION IF NOT EXISTS pgcrypto;
- CREATE SCHEMA IF NOT EXISTS itscaro;
- CREATE DOMAIN public.tag3level AS ltree
- constraint tag3level_check CHECK (public.nlevel(VALUE) = 3);
- CREATE OR REPLACE FUNCTION public.is_valid_array_tag3level(ltree[])
- RETURNS boolean AS
- $BODY$
- SELECT NOT EXISTS (
- SELECT 1
- FROM unnest ($1) tag
- WHERE tag operator(public.<>) tag::public.tag3level
- )
- $BODY$
- LANGUAGE sql IMMUTABLE STRICT;
- CREATE DOMAIN tag3level_array AS ltree[] CHECK ((public.is_valid_array_tag3level(VALUE)));
- CREATE TABLE IF NOT EXISTS itscaro.test
- (
- id int,
- tag public.tag3level_array DEFAULT '{}'
- );
- insert into itscaro.test values (2, '{test1.test2.test3}');
- -- NOTE: initial data copy is done correctly
- -- Pub/Sub
- -- Master
- CREATE PUBLICATION itscaro_test
- FOR TABLE itscaro.test;
- -- Slave
- -- On slave as this moment we have all domains, functions, extensions and testing table
- CREATE SUBSCRIPTION itscaro_test
- CONNECTION 'postgresql://postgres@<FILL IN MASTER IP>/postgres'
- PUBLICATION itscaro_test;
- -- Inserting new data after subscription is registered
- insert into itscaro.test values (2, '{tefghjfgqst.qdqsdsq.qdqsdgfjhfghqs}'),
- (3, '{teqghjghjgfst.qdqsdsq.qdqsdqssqdqsdqsd}'),
- (4, '{tjgfjhghjgfjheqst.qdqqsdqsdjghjdsdsq.qdqsdqsqsdqsdqs}'),
- (5, '{teqsqsdqsdqsdqsdqs.qdqsdsq.qdqsqsddazfdgfdhgfjhgfjhgdqs}'),
- (6, '{teqdqqsdqsdqsdqsdqsst.qdqsdsq.qdqsdqs}'),
- (7, '{teqst.qdqsdsq.qdqsdqsdqsdqsdqsdqsqs}'),
- (8, '{teqsdqsdqssazdazdqdqsdqsdsqdqsdqst.qdqsdsq.qdqsdsdsqdqsdqsqs}'),
- (9, '{teqqsdqsdqsdqsdqsdqsdqsdqsdqsst.qdqsdsq.qdqsdqsdqsdqsdqsqs}');
- --
- -- After executing the insert batch on master, failure occurs on slave
- --
- -- 2018-07-28 10:46:05.230 CEST [3132] LOG: database system is ready to accept connections
- -- 2018-07-28 10:46:05.240 CEST [3705] LOG: logical replication apply worker for subscription "itscaro_test" has started
- -- 2018-07-28 10:46:05.269 CEST [3132] LOG: worker process: logical replication worker for subscription 275990 (PID 3705) was terminated by signal 11: Segmentation fault
- -- 2018-07-28 10:46:05.269 CEST [3132] LOG: terminating any other active server processes
- -- 2018-07-28 10:46:05.274 CEST [3702] WARNING: terminating connection because of crash of another server process
Add Comment
Please, Sign In to add comment