From 16e0c5a88fac5f3e5f2a45e4d1771229f518f894 Mon Sep 17 00:00:00 2001
From: Boss Marco <bossm8@bfh.ch>
Date: Thu, 12 May 2022 22:44:40 +0200
Subject: logical replication implemented

---
 configs/etc/taler/conf.d/auditor.conf |  2 ++
 experiment/scripts/auditor.sh         | 16 ++++------------
 2 files changed, 6 insertions(+), 12 deletions(-)

diff --git a/configs/etc/taler/conf.d/auditor.conf b/configs/etc/taler/conf.d/auditor.conf
index 501d272..52a4ac8 100644
--- a/configs/etc/taler/conf.d/auditor.conf
+++ b/configs/etc/taler/conf.d/auditor.conf
@@ -9,6 +9,8 @@ DB = postgres
 SERVE = unix
 UNIXPATH = /var/run/taler/auditor-httpd/auditor.sock
 
+TINY_AMOUNT = KUDOS:0.01
+
 [auditordb-postgres]
 
 CONFIG = postgresql:///auditor
diff --git a/experiment/scripts/auditor.sh b/experiment/scripts/auditor.sh
index d602214..32406d1 100644
--- a/experiment/scripts/auditor.sh
+++ b/experiment/scripts/auditor.sh
@@ -44,24 +44,14 @@ psql postgres -tAc "SELECT 1 FROM pg_roles WHERE rolname='auditor-ingress'" | \
 psql postgres -tAc "SELECT 1 FROM pg_roles WHERE rolname='auditor'" | \
   grep -q 1 || \
   createuser auditor
-psql postgres -tAc "SELECT 1 FROM pg_roles WHERE rolname='sync'" | \
-  grep -q 1 || \
-  createuser sync
 
 createdb -O auditor-ingress "exchange-ingress"
 createdb -O auditor "auditor"
 EOF
   
   su auditor-ingress << EOF
-psql -d exchange-ingress -U auditor-ingress -tAc 'GRANT ALL ON ALL TABLES IN SCHEMA public TO sync;'
+psql -d exchange-ingress -U auditor-ingress -tAc 'GRANT ALL ON ALL TABLES IN SCHEMA public TO auditor;'
 EOF
-
-  # Only needed if we want to repicate this database again
-  # 
-  #createdb -O sync exchange-production
-  #createdb -O auditor-wire libeufin
-  #psql -d exchange-prodution -U sync -tAc 'GRANT SELECT ON ALL TABLE IN SCHEMA public TO auditor;'
-  #psql -d libeufin -U auditor-wire -tAc 'GRANT SELECT ON ALL TABLE IN SCHEMA public TO auditor;'
 }
 
 function setup_exchange_replication() {
@@ -81,7 +71,9 @@ function setup_exchange_replication() {
   DB_USER=egress wait_for_db   
 
   su postgres << EOF
-  psql -d exchange-ingress -tAc "CREATE SUBSCRIPTION IF NOT EXISTS ${NODE_NAME} CONNECTION 'postgresql://egress:${DB_PASSWORD}@${DB_HOSTS}/${DB_NAME}' PUBLICATION exchange;"
+  psql -d exchange-ingress -tAc "ALTER SUBSCRIPTION ${NODE_NAME} DISABLE;"
+  psql -d exchange-ingress -tAc "ALTER SUBSCRIPTION ${NODE_NAME} SET (slot_name=NONE);"
+  psql -d exchange-ingress -tAc "CREATE SUBSCRIPTION ${NODE_NAME} CONNECTION 'postgresql://egress:${DB_PASSWORD}@${DB_HOSTS}/${DB_NAME}' PUBLICATION exchange;" || true
 EOF
 }
 
-- 
cgit v1.2.3