...
No Format |
---|
# download cd /tmp wget https://download.clazzes.org/pg_fix_usermappings/pg_fix_usermappings.sh#sh # make it executable, for user postgres chmod ugo+rx pg_fix_usermappings.sh # it's safe to call the script without any parameters ... pg_fix_usermappings.sh # execute for 9.6 as root sudo -u postgres pg_fix_usermappings.sh 9.6 # or execute for 9.6 as non-root sudo sudo -u postgres pg_fix_usermappings.sh 9.6 # or execute for 9.6 for the bold skipping do-you-really-want-it backcheck sudo sudo -u postgres pg_fix_usermappings.sh --yes 9.6 # or execute logging the output ( sudo sudo -u postgres pg_fix_usermappings.sh 9.6 ) 2>&1 |tee /var/tmp/pg_fix_usermappings.log # after success sudo mv /var/tmp/pg_fix_usermappings.log /var/log/postgresql/ |
...