aboutsummaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorQuentin <quentin@deuxfleurs.fr>2019-06-01 16:02:49 +0200
committerQuentin Dufour <quentin@deuxfleurs.fr>2019-07-11 09:33:07 +0200
commit61d009f18d5886db8b22ae41e04bb41a4ba2fddb (patch)
treee44bb326caf3107653c7a48749527cfd77f02cf2 /doc
downloadinfrastructure-61d009f18d5886db8b22ae41e04bb41a4ba2fddb.tar.gz
infrastructure-61d009f18d5886db8b22ae41e04bb41a4ba2fddb.zip
Initial commit
Diffstat (limited to 'doc')
-rw-r--r--doc/create_database/README.md15
-rw-r--r--doc/init_stolon/README.md31
2 files changed, 46 insertions, 0 deletions
diff --git a/doc/create_database/README.md b/doc/create_database/README.md
new file mode 100644
index 0000000..7084a10
--- /dev/null
+++ b/doc/create_database/README.md
@@ -0,0 +1,15 @@
+```bash
+ssh root@<one node of the cluster>
+docker run -t -i superboum/amd64_postgres:v1
+psql -h psql-proxy.service.2.cluster.deuxfleurs.fr -p 25432 -U postgres -W postgres
+```
+
+```sql
+CREATE USER seafile;
+CREATE DATABASE seafile ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' template=template0 OWNER seafile;
+-- GRANT ALL PRIVILEGES ON DATABASE seafile TO seafile;
+```
+
+```
+consul kv import @ldapkv_seafile.json
+```
diff --git a/doc/init_stolon/README.md b/doc/init_stolon/README.md
new file mode 100644
index 0000000..fe3a912
--- /dev/null
+++ b/doc/init_stolon/README.md
@@ -0,0 +1,31 @@
+Spawn container:
+
+```bash
+docker run -t -i superboum/arm32v7_postgres:v6
+# OR
+docker run -t -i superboum/amd64_postgres:v1
+```
+
+
+Init with:
+
+```
+stolonctl \
+ --cluster-name pissenlit \
+ --store-backend=consul \
+ --store-endpoints http://consul.service.2.cluster.deuxfleurs.fr:8500 \
+ init \
+ '{ "initMode": "new", "pgHBA": [ "host all postgres all md5", "host replication replicator all md5", "host all all all ldap ldapserver=bottin.service.2.cluster.deuxfleurs.fr ldapbasedn=\"ou=users,dc=deuxfleurs, dc=fr\" ldapbinddn=\"<bind_dn>\" ldapbindpasswd=\"<bind_pwd>\" ldapsearchattribute=\"cn\"" ] }'
+
+```
+
+Then set appropriate permission on host:
+
+```
+chown -R 102:102 /mnt/storage/postgres/
+```
+
+(102 is the id of the postgres user used in Docker)
+It might be improved by staying with root, then chmoding in an entrypoint and finally switching to user 102 before executing user's command.
+Moreover it would enable the usage of the user namespace that shift the UIDs.
+