Hi!
Can I confirm that superuser access is not required on postgres after installation? Upgrades use flyway, and this doesn't require superuser access as only tables are created/dropped but entire databases are not created, correct?
To check privileges:
\du+
Postgres admin password - We’ll need it in order to create the database and user for the Dataverse Software installer to use, without having to run the installer as root. If you don’t know your Postgres admin password, you may simply set the authorization level for localhost to “trust” in the PostgreSQL pg_hba.conf file (See the PostgreSQL section in the Prerequisites). If this is a production environment, you may want to change it back to something more secure, such as “password” or “md5”, after the installation is complete.
Kind regards,
Eunice