Re: [RFC][PATCH] Logical Replication/BDR prototype and architecture
От | Andres Freund |
---|---|
Тема | Re: [RFC][PATCH] Logical Replication/BDR prototype and architecture |
Дата | |
Msg-id | 201206131952.41007.andres@2ndquadrant.com обсуждение исходный текст |
Ответ на | [RFC][PATCH] Logical Replication/BDR prototype and architecture (Andres Freund <andres@2ndquadrant.com>) |
Список | pgsql-hackers |
Hi, The patch as of yet doesn't contain how you actually can use the prototype... Obviously at this point its not very convenient: I have two config files: Node 1: port = 5501 wal_level = logical max_wal_senders = 10 wal_keep_segments = 200 multimaster_conninfo = 'port=5502 host=/tmp' multimaster_node_id = 1 Node 2: port = 5502 wal_level = logical max_wal_senders = 10 wal_keep_segments = 200 multimaster_conninfo = 'port=5501 host=/tmp' multimaster_node_id = 2 after initdb'ing the first cluster (initdb required): $ ~/src/postgresql/build/assert/src/backend/postgres -D ~/tmp/postgres/bdr/1/datadir/ -c config_file=~/tmp/postgres/bdr/1/postgresql.conf -c hba_file=~/tmp/postgres/bdr/1/pg_hba.conf -c ident_file=~/tmp/postgres/bdr/1/pg_ident.conf $ psql -p 5501 -U andres postgres CREATE TABLE data(id serial primary key, data bigint); ALTER SEQUENCE data_id_seq INCREMENT 2; SELECT setval('data_id_seq', 1); shutdown cluster $ rsync -raxv --delete /home/andres/tmp/postgres/bdr/1/datadir/* /home/andres/tmp/postgres/bdr/2/datadir start both cluster which should sync after some output. $ psql -p 5501 -U andres postgres SELECT setval('data_id_seq', 2);
В списке pgsql-hackers по дате отправления: