diff options
| author | Quentin <quentin@deuxfleurs.fr> | 2020-09-12 10:03:48 +0200 |
|---|---|---|
| committer | Quentin <quentin@deuxfleurs.fr> | 2020-09-12 10:03:48 +0200 |
| commit | c4a6cf1534b864d3941c839d4a4dca7e505bd828 (patch) | |
| tree | 3e866768cf39ae947def5b205f74fddfb435725d /op_guide/create_database | |
| parent | 0550647b9348d1e36431400e0832b4340564c658 (diff) | |
| download | infrastructure-c4a6cf1534b864d3941c839d4a4dca7e505bd828.tar.gz infrastructure-c4a6cf1534b864d3941c839d4a4dca7e505bd828.zip | |
Rebase first step
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 +``` |