This requires superuser privileges, which we don't set by default in the installer.  Could you update the manual please to suggest people do:

    # sudo -u postgres psql -c 'ALTER USER foreman WITH SUPERUSER'
    ALTER ROLE
    # sudo -u postgres psql -c 'ALTER USER foreman WITH NOSUPERUSER'
    ALTER ROLE