diff options
| author | Quentin <quentin@deuxfleurs.fr> | 2020-09-13 12:03:07 +0200 |
|---|---|---|
| committer | Quentin <quentin@deuxfleurs.fr> | 2020-09-13 12:03:07 +0200 |
| commit | 484c3fe667cd8c5a647256cb78f05c8a39b835b1 (patch) | |
| tree | 7be3c868ce1d0e0c96125a4c94cadce429be9e1d /op_guide/create_database | |
| parent | 0550647b9348d1e36431400e0832b4340564c658 (diff) | |
| parent | d5bfc38fe826aa12f46de64790195cc8e76756de (diff) | |
| download | infrastructure-484c3fe667cd8c5a647256cb78f05c8a39b835b1.tar.gz infrastructure-484c3fe667cd8c5a647256cb78f05c8a39b835b1.zip | |
Merge branch 'feature/rebase'
Diffstat (limited to 'op_guide/create_database')
| -rw-r--r-- | op_guide/create_database/README.md | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/op_guide/create_database/README.md b/op_guide/create_database/README.md new file mode 100644 index 0000000..7084a10 --- /dev/null +++ b/op_guide/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 +``` |