I’m trying to install the latest Nextcloud on Debian Stretch with postgresql and nginx. I installed all of the required dependencies, however I keep getting this error when trying to create the admin account:
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE  FATAL: permission denied for database "nextcloud"
DETAIL: User does not have CONNECT privilege.
I have no problems logging into phpPgAdmin with this user. I also altered my pg_ha.conf by adding this line:
local all all trust
I also tried to execute this as the postgres user in the psql console
GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nuser;
… all to no avail.
I have no idea what more I could try. I’d very much appreciate any sort of guidance.