joshuacox/mkpostgres

Make a persistent postgres container PDQ

mkpostgres

Make a persistent postgres container PDQ!

Usage

Initialization or Temp use

make temp will make a temporary ephemeral fresh postgresql instance

make templogs to watch the postgresql process startup and initialize its databases

you now have a fresh postgres install to experiment with you can stop here and start playing with postgres IF you do not need persistent data

Persistent Data

when the initialization of the temp container finishes (not before) you can then make grab which will make a datadir in the current directory and copy out /var/lib/postgresql out of the temporary container to be used in a persistent setup

at this point you can move the datadir wherever you so desire, just be sure and update the POSTGRES_DATADIR file in this directory as that is how the makefile knows where to mount from

Removal of the temp container

make rmtemp will clean up our temporary container, but will not delete the datadir

Production

We are now set to start our persistent database

make prod will then use the datadir and start up our container in persistent mode

Import

alternative to make temp is the make import which will mount docker-entrypoint-initdb.d into the container, at which point entry-point.sh will execute everything in there that ends in .sh or .sql

Restart

restart the container with make rm followed by make prod

Migration

to migrate simply tar up this directory along with the datadir and move to the new docker host

mkpostgres's Issues

Name container may be better as an optional config

Not sure how much I care about the container names. I like the way Compose handles this {foldername}_{service_name}. For this I think it would be fine to just do the folder name. It would look something like this.

my_app/
Dockerfile.app <- my pthon image
my_app_db/
Dockerfile.db <- my db image

make temp should just attach to stdout

Another nit pick, but i'm personally ALWAYS typing make templogs after i run a make temp.

The use case of just spinning up a DB in the background can be handled by passing in a -d flag perhaps.

make temp fails if image isn't pulled

It should pull the image if its not there locally

config to name the db

..would be useful.

configurable postgres version

...would be neato.

Script fails if docker host isn't reachable

Definitely a nit pick... but i'm on OSX and my docker host wasn't spun up, I did a $ make temp and got a big ol error... seems like this could be handled?

➜ make temp
cat: postgresqlcid: No such file or directory
docker: "kill" requires a minimum of 1 argument.
See 'docker kill --help'.

Usage:  docker kill [OPTIONS] CONTAINER [CONTAINER...]

Kill a running container
make: [kill] Error 1 (ignored)
cat: postgresqlcid: No such file or directory
docker: "rm" requires a minimum of 1 argument.
See 'docker rm --help'.

Usage:  docker rm [OPTIONS] CONTAINER [CONTAINER...]

Remove one or more containers
make: [rm-image] Error 1 (ignored)
rm: postgresqlcid: No such file or directory
make: [rm-image] Error 1 (ignored)
docker run \
    --cidfile="postgresqltemp" \
    --name `cat NAME`-postgresqltemp \
    -e POSTGRES_ROOT_PASSWORD=`cat POSTGRES_PASS` \
    -d \
    postgres:9
docker: Cannot connect to the Docker daemon. Is the docker daemon running on this host?.
See 'docker run --help'.
make: *** [postgresqltemp] Error 125

Doesn't work until you do a make prod

Something is up with the makefile, it APPEARS that the file postgresqlcid is not being created. Trying to learn enougha bout make to submit a PR :) haha.

Enter the postgresql password you wish to associate with this container [POSTGRES_PASS]: nprima
nprima
Enter the name you wish to associate with this container [NAME]: nprimadb
nprimadb
------KEY ERROR --->  cat: postgresqlcid: No such file or directory*** <---- KEY ERROR ---
docker: "kill" requires a minimum of 1 argument.
See 'docker kill --help'.

Usage:  docker kill [OPTIONS] CONTAINER [CONTAINER...]

Kill a running container
make: [kill] Error 1 (ignored)
cat: postgresqlcid: No such file or directory
docker: "rm" requires a minimum of 1 argument.
See 'docker rm --help'.

Usage:  docker rm [OPTIONS] CONTAINER [CONTAINER...]

Remove one or more containers
make: [rm-image] Error 1 (ignored)
rm: postgresqlcid: No such file or directory
make: [rm-image] Error 1 (ignored)
docker run \
    --cidfile="postgresqltemp" \
    --name `cat NAME`-postgresqltemp \
    -e POSTGRES_ROOT_PASSWORD=`cat POSTGRES_PASS` \
    -d \
    postgres:9
6fc07cf4d75c706ae23c882b4dab385d3a26de2db82add4cfa9d578edd7d5f21