postgres.git / summary / log / commit / refs

commit    77ade60a0a3a55ce5e591cd02616fe08a0acc806
Author:   John Naylor <john.naylor@postgresql.org>
Date:     Wed Jan 07 09:02:19 2026 +0000
First released in: 14.21, 15.16, 16.12, 17.8, 18.2

    createuser: Update docs to reflect defaults
    
    Commit c7eab0e97 changed the default password_encryption setting to
    'scram-sha-256', so update the example for creating a user with an
    assigned password.
    
    In addition, commit 08951a7c9 added new options that in turn pass
    default tokens NOBYPASSRLS and NOREPLICATION to the CREATE ROLE
    command, so fix this omission as well for v16 and later.
    
    Reported-by: Heikki Linnakangas <hlinnaka@iki.fi>
    Discussion: https://postgr.es/m/cff1ea60-c67d-4320-9e33-094637c2c4fb%40iki.fi
    Backpatch-through: 14


 doc/src/sgml/ref/createuser.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml
index 5c34c623423..0c061428514 100644
--- a/doc/src/sgml/ref/createuser.sgml
+++ b/doc/src/sgml/ref/createuser.sgml
@@ -539,7 +539,7 @@ PostgreSQL documentation
 <prompt>$ </prompt><userinput>createuser -P -s -e joe</userinput>
 <computeroutput>Enter password for new role: </computeroutput><userinput>xyzzy</userinput>
 <computeroutput>Enter it again: </computeroutput><userinput>xyzzy</userinput>
-<computeroutput>CREATE ROLE joe PASSWORD 'md5b5f5ba1a423792b526f799ae4eb3d59e' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;</computeroutput>
+<computeroutput>CREATE ROLE joe PASSWORD 'SCRAM-SHA-256$4096:44560wPMLfjqiAzyPDZ/eQ==$4CA054rZlSFEq8Z3FEhToBTa2X6KnWFxFkPwIbKoDe0=:L/nbSZRCjp6RhOhKK56GoR1zibCCSePKshCJ9lnl3yw=' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS;</computeroutput>
 </screen>
     In the above example, the new password isn't actually echoed when typed,
     but we show what was typed for clarity.  As you see, the password is


[parent: cdcab17e7e5d]