Docker-compose postgres volume not persisting

Question

Not sure why, my docker compose file is:

services:
  db:
    image: "postgres:latest"
    ports:
      - "5432:5432"
    volumes:
      - ods:/var/postgresql/data
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=ods

volumes:
  ods:

when I do docker volume ls I can see the line

local postgres_ods

has been created (not sure why it has added postgres_ to the front)

I will then create a table, save it, commit it, add some data to it.

do a docker compose down then a docker compose up -d

I find that the data and the table has gone missing.

inspecting postgres_ods gives me:

[
    {
        "CreatedAt": "2021-11-17T00:26:15Z",
        "Driver": "local",
        "Labels": {
            "com.docker.compose.project": "postgres",
            "com.docker.compose.version": "2.0.0",
            "com.docker.compose.volume": "ods"
        },
        "Mountpoint": "/var/lib/docker/volumes/postgres_ods/_data",
        "Name": "postgres_ods",
        "Options": null,
        "Scope": "local"
    }
]

what am I doing wrong?

James · Accepted Answer · 2021-11-17 01:32:09Z

1

Wrong folder mapped, that is why the data didn't stick around:

version: "3.9"
services:
  db:
    image: "postgres:latest"
    ports:
      - "5432:5432"
    volumes:
      - ods:/var/lib/postgresql/data
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=ods

volumes:
  ods:

answered Nov 17, 2021 at 1:32

James

3863 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ccallendar Over a year ago

As James said - the volume path must be correct. If you are using a different postgres image like the bitnami one - make sure you use the right path (/bitnami/postgresql).

Collectives™ on Stack Overflow

Docker-compose postgres volume not persisting

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related