I’m trying to set up Nextcloud (15.0.7) with Postgres (11.2) on a Raspberry Pi 2B+ with Ubuntu Server 19.04. I have a database created (
nextcloud) with a role
nextcloud with login and a password, with ownership of the
nextcloud database, all privileges on that database, and permissions to create databases and create roles. I’ve confirmed I can log in as the user with
psql -U nextcloud using the password. I made the database with the instructions in the manual.
However, when running the set up I get the error: 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’ve double checked with
GRANT CONNECT ON DATABASE nextcloud TO nextcloud;.