Hi Fontana, This is a pgAdmin mailing list and does not support slonik. Probably, ask the question to the slonik team.
On Mon, Jun 8, 2020 at 6:41 PM Fontana Daniel C (Desartec S.R.L.) < desartec...@gmail.com> wrote: > Hi i am trying to do my first sync with slony 2.2.6. and PostgreSQL version > 10 > > Server IP = 192.168.1.229 > Slave IP = 192.168.1.252 > > Just a basic table > CREATE TABLE dba.prueba > ( > id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 > START > 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), > descripcion character(100) COLLATE pg_catalog."default" NOT NULL, > CONSTRAINT prueba_pkey PRIMARY KEY (id) > ) > WITH ( > OIDS = FALSE > ) > TABLESPACE pg_default; > > ALTER TABLE dba.prueba > OWNER to postgres; > > On the master node > > cluster name = sync_articulos; > node 1 admin conninfo = 'dbname = 30711404879 host = 192.168.1.229 port = > 5434 user = replicator password = 1234'; > node 2 admin conninfo = 'dbname = 30711404879 host = 192.168.1.252 port = > 5434 user = replicator password = 1234'; > INIT CLUSTER ( ID = 1, COMMENT = 'nodo maestro' ); > CREATE SET ( ID = 1, ORIGIN = 1, COMMENT = 'aqui van todas mis tablas' ); > set add table (set id=1, origin=1, id=1, fully qualified name = > 'dba.prueba', comment = 'tabla articulos'); > store node (id = 2, comment = 'nodo esclavo', EVENT NODE = 1); > store path (server = 1, client = 2, conninfo = 'dbname = 30711404879 host = > 192.168.1.229 user = replicator password = 1234'); > store path (server = 2, client = 1, conninfo = 'dbname = 30711404879 host = > 192.168.1.252 user = replicator password = 1234'); > store listen (origin = 1, provider = 1, receiver = 2); > store listen (origin = 2, provider = 2, receiver = 1); > > When i run > > C:\Program Files\PostgreSQL\10\bin>slonik maestro.com > maestro.com:14: Possible unsupported PostgreSQL version (101300) 10.13, > defaulti > ng to 8.4 support > maestro.com:34: Possible unsupported PostgreSQL version (101300) 10.13, > defaulti > ng to 8.4 support > maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2 > maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2 > maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2 > and continues..... > > on the slave node > > cluster name = sync_articulos; > node 1 admin conninfo = 'dbname = 30711404879 host = 192.168.1.229 port = > 5434 user = replicator password = 1234'; > node 2 admin conninfo = 'dbname = 30711404879 host = 192.168.1.252 port = > 5434 user = replicator password = 1234'; > SUBSCRIBE SET ( ID = 1, PROVIDER = 1, RECEIVER = 2, FORWARD = YES); > > When i run > > c:\Program Files\PostgreSQL\10\bin>slonik esclavo.com > waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1 > waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1 > waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1 > and continues..... > > > !these processes never end!, what is the problem? > > > > > -- Thanks and Regards, Aditya Toshniwal pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
