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
postgresql [2018/08/27 13:41]
mantis
postgresql [2020/07/15 09:42] (current)
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)
postgresql.txt ยท Last modified: 2020/07/15 09:42 by mstraub