Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Linebreaks, safe accident

...

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/

...