Docker postgresql container with external data container

Question

I have a data container with Dockerfile:

from ubuntu:latest

VOLUME ["/var/lib/postgresql/9.3/main"]

and a postgresql service container:

#install stuff
............

# Set the default command to run when starting the container
CMD  ["/usr/lib/postgresql/9.3/bin/postgres", "-D", "/var/lib/postgresql/9.3/main", "-c", "config_file=/etc/postgresql/9.3/main/postgresql.conf"]

then I start the data container and postgresql container:

docker run -i -t -d --name data docker:data

docker run -i -t -p 49131:5432 --name postgresql --volumes-from data --rm docker:postgresql

it says :

FATAL:  data directory "/var/lib/postgresql/9.3/main" has wrong ownership
HINT:  The server must be started by the user that owns the data directory.

it seems like the /var/lib/postgresql/9.3/main folder belong to the root user in the data container. Then i attach to the container, add user and change owner of that folder to postgres:

docker attach data
useradd postgres -s /bin/bash
chown -R postgres:postgres /var/lib/postgresql

then try again with the same error.

what is the problem and what am i missing?

Adrian Mouat · Accepted Answer · 2015-02-28 11:40:04Z

8

The postgres user probably hasn't been assigned the same UID in the separate containers.

There's no need to make it this difficult though, just use the postgres image to create your data container e.g:

docker run --name data-container postgres echo "Data Container"

That way all the permissions will be set up correctly. For more information see:

edited Feb 28, 2015 at 11:40

answered Feb 28, 2015 at 9:46

Adrian Mouat

46.9k17 gold badges114 silver badges106 bronze badges

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

1 Comment

Kevin Over a year ago

thanks, using the postgresql image solved the problem!

Collectives™ on Stack Overflow

Docker postgresql container with external data container

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