How do i get postgres data to persist using docker-compose

Question

I keep losing my data when i restart my docker, here is my docker-compose.yml

postgres:
  image: postgres
  volumes:
    - /data/myproject/postgres:/var/lib/postgresql/data
  ports:
    - '15432:5432'
  environment:
    POSTGRES_PASSWORD: mypassword
    POSTGRES_USER: mypassword

Any help would be appreciated, thanks

Community · Accepted Answer · 2017-05-23 10:27:58Z

1

Since you are using boot2docker, you need to know that only /Users is shared between the host (a Mac for instance) and the docker VM.

That means when you restart your VM, anything stored outside /Users (like /data/myproject/postgres) would be lost.

Try mounting a volume with a host path which is actually shared between your host and your VM.

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Nov 19, 2015 at 15:02

VonC

1.4m568 gold badges4.8k silver badges5.7k bronze badges

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

5 Comments

Mr Mixin Over a year ago

thanks for the response, so you mean if m host machine is an ubuntu vm i need to map it to any dir in /home/<vm-username>/ ?

VonC Over a year ago

@MrMixin No: your host machine would be a Mac or a Windows if you need a boot2docker VM.

VonC Over a year ago

@MrMixin If your host was Ubuntu, you wouldn't need a boot2docker VM. Even if your host is using an Ubuntu VM, you wouldn't need boot2docker since you would do docker directly within the Ubuntu VM.

Dr Manhattan Over a year ago

So on a MAC system with boot2docker would he put his path as /Users/data/myproject/postgress instead of /data/myproject/postgres

VonC Over a year ago

@DrManhattan Yes, that is the idea.

Collectives™ on Stack Overflow

How do i get postgres data to persist using docker-compose

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related