Can't create superuser; script fails to find/connect to Postgres DB

[cj-wong]

Hi,

I am having issues proceeding with installation. I am trying to get paperless-ng working on an amd64 server via docker-compose. I have downloaded the required files and even successfully got to step 6 outlined in setup.

I have made some changes to the default configuration, such as using local volumes (rather than in the volumes: section) and using an arbitrary user for the Postgres service. I also run docker-compose with sudoers permissions to avoid directly giving the dedicated user (named paperless-ng) the docker group.

Here's the error in question:

$ sudo docker-compose run --rm webserver createsuperuser
Starting paperless_broker_1    ... done
Starting paperless_tika_1      ... done
Starting paperless_db_1        ... done
Starting paperless_gotenberg_1 ... done
Paperless-ng docker container starting...
Mapping UID and GID for paperless:paperless to 1024:1026
Creating directory /tmp/paperless
Adjusting permissions of paperless files. This may take a while.
Waiting for PostgreSQL to start...
/sbin/docker-prepare.sh: line 16: db: No address associated with hostname
/sbin/docker-prepare.sh: line 16: /dev/tcp/db/5432: Invalid argument
Attempt 1 failed! Trying again in 5 seconds
...

I cut it short a little, but it basically tries the last 3 lines 4 more times and quits.

Host OS: Ubuntu 20.04 LTS
Host Arch: amd64
Docker version: 20.10.7, build f0df350
docker-compose version: 1.25.0, build unknown

Files:
docker-compose.yml.txt
docker-compose.env.txt

[cj-wong]

Update:

It turns out that I encountered a very similar problem on another Docker project that also uses Postgres and narrowed down the error. Instead of specifying UID and GID as environment variables in the Postgres service, I had to use User: $UID:$GID instead.

Apologies for this problem.