[taler-grid5k] 19/48: logical replication implemented

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 16e0c5a88fac5f3e5f2a45e4d1771229f518f894
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Thu May 12 22:44:40 2022 +0200

    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
 }
 

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.