Persistent database with docker-compose in DigitalOcean

Question

I am running a docker-compose project in a DigitalOcean Docker droplet.

I also have a persistent volume. It has been mounted on /mnt/volume_fra1_01

In my docker-compose.yml, I defined the volume for the database:

...

db:
    image: postgres:12.0-alpine
    volumes:
      - postgres_data:/var/lib/postgresql/data/
    env_file:
      - ./postgres/.env

...

volumes:
  postgres_data:

...

and I've created the symbolic link with sudo ln -s /mnt/volume_fra1_01 postgres_data

But I the database is not persistent. When I purge the containers the database is gone. Somehow /var/lib/postgresql/data/ is not using the mounted volume.

Raphael PICCOLO · Accepted Answer · 2021-06-23 09:25:23Z

0

when you write this :

- postgres_data:/var/lib/postgresql/data/

postgres_data is a named volume. not a local folder. Is this what digital ocean told you to do ?

can you try with this :

- ./postgres_data:/var/lib/postgresql/data/

answered Jun 23, 2021 at 9:25

Raphael PICCOLO

2,1881 gold badge16 silver badges20 bronze badges

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

1 Comment

mehrlicht Over a year ago

Thanks. But this way it returns 502 Bad Gateway when trying to access the administration area (and presumably with all accesses to the database)

Darial · Accepted Answer · 2021-06-23 13:38:56Z

0

Can you try to configure your volumes without the symbolik link :

volumes:
  - /mnt/volume_fra1_01:/var/lib/postgresql/data/

Should work.

answered Jun 23, 2021 at 13:38

Darial

437 bronze badges

1 Comment

mehrlicht Over a year ago

Thanks for the suggestion but it does not work: db: forward host lookup failed: Unknown host

Collectives™ on Stack Overflow

Persistent database with docker-compose in DigitalOcean

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related