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