Hello, I have installed Nextcloud and it is working fine.
When I want to connect to the database, for example to make backups, I can connect with this command:
docker exec -it db-nextcloud bash -c ‘PGPASSWORD=MYPASSWORD psql -p 5432 -h db-nextcloud --username=oc_casaos --dbname=nextcloud’
However, when I use CloudBeaver or adminer I cannot connect to the database.
In postgresql.conf listen_addresses is set to ‘*’.
In pg_hba.conf I have added this lines:
host all all all trust
host all all all md5
In CloudBeaver I always get this error:
Error connecting to database:
Connection failed:
The connection attempt failed.
Any idea what could be the problem?
What is the suggested way to backup the Postgressql database?