search

juliushaertl / nextcloud-docker-dev

Nextcloud development environment using docker-compose
GNU Affero General Public License v3.0
126 stars 67 forks source link

role "nextcloud" does not exist #324

Open yuriry opened 2 months ago

yuriry commented 2 months ago

A question about docs/services/database.md:

When I run docker compose exec postgres psql -U nextcloud -d nextcloud, I get error: service "postgres" is not running.

When I change postgres to database-pgsql, I get error: FATAL: role "nextcloud" does not exist.

When I change -U nextcloud to -U postgres, I can connect to the database. And when I run select * from pg_user;, I get only one row with usename postgres.

Is my setup incorrect, or is it a typo in documentation?

juliushaertl commented 2 months ago

Did you change your setup in the .env file to use postgres instead of the default mysql? The postgres container will only be used then, any users would only get created during installation of the Nextcloud container

yuriry commented 2 months ago

Yes, I ran docker compose down -v, then changed the .env file, then docker compose up -d nextcloud It looks like the service to connect to is database-pgsql, but it has no nextcloud role, only postgres.