diff options
Diffstat (limited to 'doc')
-rw-r--r-- | doc/create_database/README.md | 15 | ||||
-rw-r--r-- | doc/init_stolon/README.md | 31 |
2 files changed, 0 insertions, 46 deletions
diff --git a/doc/create_database/README.md b/doc/create_database/README.md deleted file mode 100644 index 7084a10..0000000 --- a/doc/create_database/README.md +++ /dev/null @@ -1,15 +0,0 @@ -```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 deleted file mode 100644 index fe3a912..0000000 --- a/doc/init_stolon/README.md +++ /dev/null @@ -1,31 +0,0 @@ -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. - |