Persisting storage issue

[stoltzmaniac]

Any ideas @tompropst about why I can't get web-db to work as a volume?

After I add the volumes section:

web-db:
    container_name: web-db
    build:
      context: ./project/server/db
      dockerfile: Dockerfile
    ports:
      - 5435:5432
    environment:
      - POSTGRES_USER=${POSTGRES_USER}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
    volumes:
      - ./backup_data/postgres:/var/lib/postgresql/data

I get an error:

Waiting for postgres...
web-db: forward host lookup failed: Unknown host
web-db: forward host lookup failed: Unknown host
....goes on like this...

Any ideas?

[tompropst]

The files at that path in the container my need to be copied on the first build, before mounting the local path which is probably empty. The unknown host error may be from some default setting. I’m out of the county this week but can help debug when I get back.

[stoltzmaniac]

Also, when I run the create-db command I wind up getting an error:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "web-db" to address: Name or service not known
 (Background on this error at: http://sqlalche.me/e/e3q8)

I'm assuming they're related

[stoltzmaniac]

Aaaand as I just tried, looks like what I had to do was write to a different directory on the container because it was not empty (or I could have removed it).

[stoltzmaniac]

I lied, still an issue... can't get this thing to mount

[stoltzmaniac]

After many stressful hours, I think I've found the problem... and it was very simple...

The volume is being referenced via a relative path that lives within the root directory. If I change it to somewhere else on the system it works... could that be accurate?

[tompropst]

I’m not sure. Are you saying that the host path ./backup_data/postgres caused the issue? Seems odd.

[stoltzmaniac]

Yeah, I'm not sure. Honestly, just can't seem to get volumes to work smoothly here. Database isn't persisting and then it pulls that can't connect stuff if I use a volume that was given in the example above