User Tools

Site Tools


postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
postgresql [2018/07/24 16:47]
mstraub [Incremental Backups on Localhost]
postgresql [2020/07/15 09:42]
mstraub
Line 44: Line 44:
 # set a password # set a password
 \password \password
 +
 +# make an existing user superuser (or remove superuser rights)
 +sudo -u postgres psql -c "ALTER USER theuser WITH SUPERUSER;"​
 +sudo -u postgres psql -c "ALTER USER theuser WITH NOSUPERUSER;"​
  
 # create a restricted user with password (long and short version) # create a restricted user with password (long and short version)
Line 58: Line 62:
 ==== Setting a password for user postgres ==== ==== Setting a password for user postgres ====
 <code sql> <code sql>
-alter user postgres ​with password '​password';​+\password ​postgres
 </​code>​ </​code>​
  
postgresql.txt ยท Last modified: 2020/07/15 09:42 by mstraub