Advertisement
Guest User

Untitled

a guest
Jun 7th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. ServPostGre:~# su postgres
  2. postgres@ServPostGre:/root$ slonik_create_set 1
  3. cluster name = teepycluster;
  4. node 1 admin conninfo='host=192.168.0.38 dbname=teepy user=slony port=5432 password=teepyrep';
  5. node 2 admin conninfo='host=192.168.0.24 dbname=teepy user=slony port=5432 password=teepyrep';
  6.  
  7. # TABLE ADD KEY
  8.  
  9. # CREATE SET
  10. try {
  11. create set (id = 1, origin = 1, comment = 'Set 1 for teepycluster');
  12. } on error {
  13. echo 'Could not create subscription set 1 for teepycluster!';
  14. exit -1;
  15. }
  16.  
  17. # SET ADD TABLE
  18. echo 'Subscription set 1 created';
  19. echo 'Adding tables to the subscription set';
  20.  
  21. # SET ADD SEQUENCE
  22. echo 'Adding sequences to the subscription set';
  23. echo 'All tables added';
  24. postgres@ServPostGre:/root$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement