X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/c01ce0788adade520dc825152685aee0449a7da4..f42ee7c19b794e25db30051b1dfc4bee83929bcd:/doc/_includes/_install_postgres_database.liquid diff --git a/doc/_includes/_install_postgres_database.liquid b/doc/_includes/_install_postgres_database.liquid index 04fbc3370a..e93457f188 100644 --- a/doc/_includes/_install_postgres_database.liquid +++ b/doc/_includes/_install_postgres_database.liquid @@ -1,15 +1,32 @@ -# Start a shell for the postgres user: - 
~$ sudo -u postgres bash
 -# Generate a new database password: - 
$ ruby -e 'puts rand(2**128).to_s(36)'
+{% comment %}
+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:
+
    # su postgres
    
+
    2. 
+
  2. Generate a new database password:
+
    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.
-# Create a database user with the password you generated:
-  
    $ createuser --encrypted -R -S --pwprompt {{service_role}}
-Enter password for new role: yourgeneratedpassword
-Enter it again: yourgeneratedpassword
-
    
-# Create a database owned by the new user:
-  
    $ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
    
-# Exit the postgres user shell:
-  
    $ exit
    
+
    3. 
+
  3. Create a database user with the password you generated:
+  
    postgres$ createuser --encrypted --no-createrole --no-superuser --pwprompt {{service_role}}
+  Enter password for new role: yourgeneratedpassword
+  Enter it again: yourgeneratedpassword
    
+
    4. 
+
  4. Create a database owned by the new user:
+  
    postgres$ createdb {{service_database}} -T template0 -E UTF8 -O {{service_role}}
    
+
    5. 
+{% if use_contrib %}
+
  5. Enable the pg_trgm extension
+  
    postgres$ psql {{service_database}} -c "CREATE EXTENSION IF NOT EXISTS pg_trgm"
    
+
    6. 
+{% endif %}
+
  6. Exit the postgres user shell:
+  
    postgres$ exit
    
+
    7. 
+