diff options
| author | Quentin <quentin@deuxfleurs.fr> | 2019-06-01 16:02:49 +0200 |
|---|---|---|
| committer | Quentin Dufour <quentin@deuxfleurs.fr> | 2019-07-11 09:33:07 +0200 |
| commit | 61d009f18d5886db8b22ae41e04bb41a4ba2fddb (patch) | |
| tree | e44bb326caf3107653c7a48749527cfd77f02cf2 /doc/create_database | |
| download | infrastructure-61d009f18d5886db8b22ae41e04bb41a4ba2fddb.tar.gz infrastructure-61d009f18d5886db8b22ae41e04bb41a4ba2fddb.zip | |
Initial commit
Diffstat (limited to 'doc/create_database')
| -rw-r--r-- | doc/create_database/README.md | 15 |
1 files changed, 15 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 +``` |