X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/b629d9e88ad0c6e62018a8fb4768013975eccc70..9cc5ed8fb634fa4f22f7bbaed8de0e5052c89f87:/doc/_includes/_install_postgres_database.liquid 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 %} -
    +
    1. Start a shell for the postgres user: -
      ~$ sudo -u postgres bash
       +
      # su postgres
    2. Generate a new database password: -
      $ ruby -e 'puts rand(2**128).to_s(36)'
+
      postgres$ tr -dc 0-9a-zA-Z </dev/urandom | head -c25; echo
 yourgeneratedpassword
 
       Record this.  You'll need it when you set up the Rails server later.
    3. Create a database user with the password you generated: - 
      $ 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
    4. Create a database owned by the new user: - 
      $ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
       + 
      postgres$ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
      5. {% if use_contrib %}
    5. Enable the pg_trgm extension - 
      $ psql {{service_database}} -c "CREATE EXTENSION IF NOT EXISTS pg_trgm"
       + 
      postgres$ psql {{service_database}} -c "CREATE EXTENSION IF NOT EXISTS pg_trgm"
      6. {% endif %}
    6. Exit the postgres user shell: - 
      $ exit
       + 
      postgres$ exit