X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/7eb7c12b0aabda5c937922a9696200ed13b5f51f..41e6ddfb673652c14020145e122d54dc6d5ba8ec:/doc/_includes/_install_postgres_database.liquid?ds=sidebyside diff --git a/doc/_includes/_install_postgres_database.liquid b/doc/_includes/_install_postgres_database.liquid index f4b95ac0be..e93457f188 100644 --- a/doc/_includes/_install_postgres_database.liquid +++ b/doc/_includes/_install_postgres_database.liquid @@ -4,29 +4,29 @@ Copyright (C) The Arvados Authors. All rights reserved. SPDX-License-Identifier: CC-BY-SA-3.0 {% endcomment %} -
~$ sudo -u postgres bash
# su postgres
$ ruby -e 'puts rand(2**128).to_s(36)' +Record this. You'll need it when you set up the Rails server later. postgres$ tr -dc 0-9a-zA-Z </dev/urandom | head -c25; echo yourgeneratedpassword
$ createuser --encrypted -R -S --pwprompt {{service_role}}
+ postgres$ createuser --encrypted --no-createrole --no-superuser --pwprompt {{service_role}}
Enter password for new role: yourgeneratedpassword
Enter it again: yourgeneratedpassword
$ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
postgres$ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
$ psql {{service_database}} -c "CREATE EXTENSION IF NOT EXISTS pg_trgm"
postgres$ psql {{service_database}} -c "CREATE EXTENSION IF NOT EXISTS pg_trgm"
$ exit
postgres$ exit