FATAL: database "dawarich" does not exist (on Synology)

[erwinelling]

OS & Hardware
DSM 7.2.2-72806 Update 4
Synology DS420+ (Intel Celeron J4025), 2GHz CPU, 10GB RAM

Version
Latest version as of 24 August 2025. (0.30.12?)

Describe the bug
Dawarich not running after fresh Docker build, potentially due to database errors: FATAL:  database "dawarich" does not exist

To Reproduce
Steps to reproduce the behavior:

1. Follow these steps https://dawarich.app/docs/tutorials/platforms/synology/
2. Also create the folder app_storage as per Update How_to_install_Dawarich_on_Synology.md #1612
3. Create the project.
4. Project builds correctly, all containers running, but the app is not reachable.

Expected behavior
Build completing, all docker containers running and app reachable.

Screenshots
None

Logs
Dawarich app log:

[...]
2025/08/24 14:32:44 | stdout | Postgres database dawarich is unavailable - retrying...
2025/08/24 14:32:42 | stdout | Postgres database dawarich is unavailable - retrying...
2025/08/24 14:32:41 | stdout | ⏳ Waiting for database dawarich to be ready...
2025/08/24 14:32:41 | stdout | Note: Database dawarich may already exist or couldn't be created now
2025/08/24 14:32:37 | stdout | Attempting to create database dawarich if it doesn't exist...
2025/08/24 14:32:37 | stdout | Setting up all required databases...
2025/08/24 14:32:36 | stdout | ⚠️ Starting Rails environment: development ⚠️

Dawarich db log:

[...]
2025/08/24 14:33:43 | stderr | 2025-08-24 12:33:43.463 UTC [68] FATAL:  database "dawarich" does not exist
2025/08/24 14:33:42 | stderr | 2025-08-24 12:33:42.576 UTC [67] FATAL:  database "dawarich" does not exist
2025/08/24 14:33:41 | stderr | 2025-08-24 12:33:41.435 UTC [1] LOG:  database system is ready to accept connections
2025/08/24 14:33:41 | stderr | 2025-08-24 12:33:41.306 UTC [63] FATAL:  the database system is starting up
2025/08/24 14:33:40 | stderr | 2025-08-24 12:33:40.749 UTC [62] LOG:  database system was shut down at 2025-08-24 12:33:37 UTC
2025/08/24 14:33:40 | stderr | 2025-08-24 12:33:40.512 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025/08/24 14:33:40 | stderr | 2025-08-24 12:33:40.272 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025/08/24 14:33:40 | stderr | 2025-08-24 12:33:40.272 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025/08/24 14:33:40 | stderr | 2025-08-24 12:33:40.272 UTC [1] LOG:  starting PostgreSQL 17.6 on x86_64-pc-linux-musl, compiled by gcc (Alpine 14.2.0) 14.2.0, 64-bit
2025/08/24 14:33:38 | stdout |  
2025/08/24 14:33:38 | stdout | PostgreSQL init process complete; ready for start up.
2025/08/24 14:33:38 | stdout |  
2025/08/24 14:33:38 | stdout | server stopped
2025/08/24 14:33:38 | stdout | done
2025/08/24 14:33:38 | stdout | 2025-08-24 12:33:38.844 UTC [40] LOG:  database system is shut down
2025/08/24 14:33:38 | stdout | .......................2025-08-24 12:33:38.826 UTC [41] LOG:  checkpoint complete: wrote 3784 buffers (23.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=5.051 s, sync=15.579 s, total=23.575 s; sync files=784, longest=1.725 s, average=0.020 s; distance=31419 kB, estimate=31419 kB; lsn=0/339BEA0, redo lsn=0/339BEA0
2025/08/24 14:33:15 | stdout | 2025-08-24 12:33:15.760 UTC [41] LOG:  checkpoint starting: shutdown immediate
2025/08/24 14:33:15 | stdout | 2025-08-24 12:33:15.252 UTC [41] LOG:  shutting down
2025/08/24 14:33:15 | stdout | 2025-08-24 12:33:15.250 UTC [40] LOG:  background worker "logical replication launcher" (PID 46) exited with exit code 1
2025/08/24 14:33:15 | stdout | waiting for server to shut down....2025-08-24 12:33:15.244 UTC [40] LOG:  aborting any active transactions
2025/08/24 14:33:14 | stdout | 2025-08-24 12:33:14.908 UTC [40] LOG:  received fast shutdown request
2025/08/24 14:33:14 | stdout |  
2025/08/24 14:33:14 | stdout | CREATE EXTENSION
2025/08/24 14:33:03 | stdout | CREATE EXTENSION
2025/08/24 14:33:03 | stdout | You are now connected to database "postgres" as user "postgres".
2025/08/24 14:33:03 | stdout | CREATE EXTENSION
2025/08/24 14:33:00 | stdout | CREATE EXTENSION
2025/08/24 14:32:55 | stdout | Loading PostGIS extensions into postgres
2025/08/24 14:32:55 | stdout | CREATE EXTENSION
2025/08/24 14:32:42 | stdout | CREATE EXTENSION
2025/08/24 14:32:42 | stdout | You are now connected to database "template_postgis" as user "postgres".
2025/08/24 14:32:41 | stdout | CREATE EXTENSION
2025/08/24 14:32:40 | stdout | CREATE EXTENSION
2025/08/24 14:32:34 | stdout | Loading PostGIS extensions into template_postgis
2025/08/24 14:32:34 | stdout | CREATE DATABASE
2025/08/24 14:32:32 | stdout | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
2025/08/24 14:32:32 | stdout |  
2025/08/24 14:32:32 | stdout | server started
2025/08/24 14:32:32 | stdout | done
2025/08/24 14:32:32 | stdout | 2025-08-24 12:32:32.577 UTC [40] LOG:  database system is ready to accept connections
2025/08/24 14:32:32 | stdout | .2025-08-24 12:32:32.475 UTC [43] LOG:  database system was shut down at 2025-08-24 12:32:27 UTC
2025/08/24 14:32:31 | stdout | 2025-08-24 12:32:31.610 UTC [40] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025/08/24 14:32:30 | stdout | waiting for server to start.....2025-08-24 12:32:30.982 UTC [40] LOG:  starting PostgreSQL 17.6 on x86_64-pc-linux-musl, compiled by gcc (Alpine 14.2.0) 14.2.0, 64-bit
2025/08/24 14:32:30 | stderr | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
2025/08/24 14:32:30 | stdout |  
2025/08/24 14:32:30 | stdout | pg_ctl -D /var/lib/postgresql/data -l logfile start
2025/08/24 14:32:30 | stdout |  
2025/08/24 14:32:30 | stdout | Success. You can now start the database server using:
2025/08/24 14:32:30 | stdout |  
2025/08/24 14:32:29 | stderr | initdb: warning: enabling "trust" authentication for local connections
2025/08/24 14:32:30 | stdout |  
2025/08/24 14:32:29 | stdout | syncing data to disk ... ok
2025/08/24 14:32:27 | stdout | performing post-bootstrap initialization ... ok
2025/08/24 14:32:26 | stderr | 2025-08-24 12:32:26.101 UTC [34] WARNING:  no usable system locales were found
2025/08/24 14:32:26 | stderr | sh: locale: not found
2025/08/24 14:32:25 | stdout | running bootstrap script ... ok
2025/08/24 14:32:25 | stdout | creating configuration files ... ok
2025/08/24 14:32:25 | stdout | selecting default time zone ... UTC
2025/08/24 14:32:24 | stdout | selecting default "shared_buffers" ... 128MB
2025/08/24 14:32:24 | stdout | selecting default "max_connections" ... 100
2025/08/24 14:32:24 | stdout | selecting dynamic shared memory implementation ... posix
2025/08/24 14:32:23 | stdout | creating subdirectories ... ok
2025/08/24 14:32:23 | stdout | fixing permissions on existing directory /var/lib/postgresql/data ... ok
2025/08/24 14:32:23 | stdout |  
2025/08/24 14:32:23 | stdout | Data page checksums are disabled.
2025/08/24 14:32:23 | stdout |  
2025/08/24 14:32:23 | stdout | The default text search configuration will be set to "english".
2025/08/24 14:32:23 | stdout | The default database encoding has accordingly been set to "UTF8".
2025/08/24 14:32:23 | stdout | The database cluster will be initialized with locale "en_US.utf8".
2025/08/24 14:32:23 | stdout |  
2025/08/24 14:32:23 | stdout | This user must also own the server process.
2025/08/24 14:32:23 | stdout | The files belonging to this database system will be owned by user "postgres".

Dawarich sidekiq log:

[...]
2025/08/24 14:33:03 | stderr | Is the server running on that host and accepting TCP/IP connections?
2025/08/24 14:33:02 | stderr | psql: error: connection to server at "dawarich_db" (192.168.240.3), port 5432 failed: Connection refused
2025/08/24 14:33:01 | stderr | Postgres is unavailable - retrying...
2025/08/24 14:33:01 | stderr | Is the server running on that host and accepting TCP/IP connections?
2025/08/24 14:33:00 | stderr | psql: error: connection to server at "dawarich_db" (192.168.240.3), port 5432 failed: Connection refused
2025/08/24 14:32:58 | stderr | Postgres is unavailable - retrying...
2025/08/24 14:32:58 | stderr | Is the server running on that host and accepting TCP/IP connections?
2025/08/24 14:32:58 | stderr | psql: error: connection to server at "dawarich_db" (192.168.240.3), port 5432 failed: Connection refused
2025/08/24 14:32:54 | stdout | ⏳ Waiting for database to be ready...
2025/08/24 14:32:54 | stdout | ⚠️ Starting Sidekiq in development environment ⚠️

Additional context
I used to have dawarich running on this machine, but broke things on an update. I decided to completely remove all containers and do a fresh build.

[cosmindv]

I can confirm this on a fresh install, i have done the same thing as you,

You can try to SSH in the nas and do the following commands:

sudo su
docker exec -it dawarich_db bash
psql -U postgres -c "CREATE DATABASE dawarich;"
or
psql -U postgres -c "CREATE DATABASE dawarich_development;"

fore some, it worked, i think there is something else wrong with my install, i can no longer get it to work.

[iandees]

This seems to have helped in my case:

sudo su
docker exec -it dawarich_db bash
psql -U postgres -c "CREATE DATABASE dawarich;"

[iandees]

After fixing the database problem the app can't connect to redis, preventing me from getting the app running. ☹️

[iandees]

I needed to add REDIS_URL=redis://dawarich_redis:6379 to the .env in the Synology directory.