autopostgresqlbackup icon indicating copy to clipboard operation
autopostgresqlbackup copied to clipboard

Offer a container distribution for autopostgresqlbackup ?

Open ieugen opened this issue 1 year ago • 1 comments

Hi,

Would you be open to offering a container version of the software? I'm asking because I checked and there are a few version but none of them is this one https://hub.docker.com/search?q=autopostgresqlbackup .

Also Debian package seems to be behind, otherwise I could have built a container from debian package. https://github.com/k0lter/autopostgresqlbackup/issues/29 .

I can contribute a container version if you are open to accepting PR's . I think that starting from a base Debian version + postgresql-client (and mysql ?! ) + this software should be enough.

Even if you do not publish it, it can be used by others to build a container from the Docker file URL , especially if the instructions are kindly provided :) .

The URL can be a git tag release reference in this case .

https://docs.docker.com/reference/cli/docker/buildx/build/ https://stackoverflow.com/a/39194765

ieugen avatar Jul 22 '24 20:07 ieugen

Hi @ieugen

Feel free to submit a PR. I will be glad to merge it.

However, I'm not sure that a Debian based image will be efficient. A very minimal Debian image is around 60 MB, if you add PostgreSQL and/or MySQL/MariaDB client, i guess it will grow to 80 MB or more.

Alpine images are very small, even with PostgreSQL and/or MySQL/MariaDB I guess that the image size should not exceed 30 MB.

k0lter avatar Nov 06 '24 06:11 k0lter

Just wondering if anything ever came of this? :)

brendon avatar Aug 03 '25 22:08 brendon

I was looking for this as well, there were a few images on DockerHub, but those all seemed to be abandoned, so I made one with the latest version of the script, and support for both MySQL and PostgreSQL.

The image is not the smallest (170 MB); I had to base it around Debian, because the script uses a few command-line parameters for the hostname and xargs commands that are not supported by the busybox version inside Alpine.

I am running it myself in two separate Docker containers (one for a MySQL server and one for a PostgreSQL server) and it seems to be doing its job rather well in this configuration. the container / git repo can be found here: https://hub.docker.com/r/jeroenkeizernl/autopostgresqlbackup https://github.com/JeroenKeizerNL/autopostgresqlbackup

JeroenKeizerNL avatar Oct 06 '25 17:10 JeroenKeizerNL

Nice work @JeroenKeizerNL . Thanks for sharing.

bullseye is kind of old Debian release though. Why not use latest - trixie ?

ieugen avatar Oct 06 '25 18:10 ieugen

Mainly because of image size, Trixie bumps it to 244 MB. but Bullseye was a bit older then I thought it was \o/. I updated the build to Trixie now.

JeroenKeizerNL avatar Oct 06 '25 19:10 JeroenKeizerNL

@JeroenKeizerNL I'm a little surprised about the 244 MB, on my side I have this:

REPOSITORY TAG               IMAGE ID       CREATED       SIZE
debian     trixie            61d0976aceca   8 days ago    120MB
debian     trixie-slim       a7aa3874b2c7   8 days ago    78.6MB

k0lter avatar Oct 07 '25 05:10 k0lter

That is the clean debian base image, right ? The 244 MB is including mariadb-client, postgresql-client-17 and the needed dependencies for those.

JeroenKeizerNL avatar Oct 07 '25 07:10 JeroenKeizerNL

@JeroenKeizerNL ah you're right

k0lter avatar Oct 11 '25 16:10 k0lter