Build Docker image with Postgres data included and use for Kubernets

Question

I am trying to build docker image with postgres data included.I am following below link.

https://sharmank.medium.com/build-postgres-docker-image-with-data-included-489bd58a1f9e

It is built with data as below.

REPOSITORY                                          TAG                 IMAGE ID            CREATED             SIZE
db_image_with_data                              latest              48b5d776e7d6        2 hours ago        1.67GB

I could see data is available in images using below command


docker run --env PGDATA=postgres -p 5432:5432 -I db_image_with_data

I have pushed same image to docker hub and I have configured same image in kubernets .

But only db has created there is no data populated in db.

kubectl exec my-database-7c4bb7bdd7-m8sjd -n dev-app -- sh -c 'psql -U "postgres" -d "devapp" -c "select * from execution_groups"'
 id | groupname | grouptype | user_id | tag | created_at | updated_at | group_id 
----+-----------+-----------+---------+--------+------------+------------+----------
(0 rows)

Is there anything i am missing out here?

coderanger · Accepted Answer · 2021-05-11 08:16:56Z

1

In the many years since that post came out, it looks like the postgres community container image has been tweaked to automatically provision a volume for the data when running under Docker (via the VOLUME directive). This means your content was stored outside the running container and thus is not part of the saved image. AFAIK this cannot be disabled so you'll have to build your own base image (or find another one to use).

answered May 11, 2021 at 8:16

coderanger

54.6k4 gold badges60 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

Build Docker image with Postgres data included and use for Kubernets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related