A Dockerfile that produces a Docker Image for PostgreSQL.
The master branch currently hosts PostgreSQL 9.6.
Different versions of PostgreSQL are located at the github repo branches.
To create the image frodenas/postgresql, execute the following command on the docker-postgresql folder:
docker build -t frodenas/postgresql .
docker build -t frodenas/postgresql:9.6 .
To run the image and bind to host port 5432:
docker run -d --name postgresql -p 5432:5432 frodenas/postgresql
The first time you run your container, a new user pgadmin with all privileges will be created with a random password.
To get the password, check the logs of the container by running:
docker logs postgresql
You will see an output like the following:
========================================================================
PostgreSQL User: "pgadmin"
PostgreSQL Password: "WH7fwqY7bJCEMYKC"
========================================================================
If you want to preset credentials instead of a random generated ones, you can set the following environment variables:
POSTGRES_USERNAME to set a specific usernamePOSTGRES_PASSWORD to set a specific passwordOn this example we will preset our custom username and password:
$ docker run -d \
--name postgresql \
-p 5432:5432 \
-e POSTGRES_USERNAME=myuser \
-e POSTGRES_PASSWORD=mypassword \
frodenas/postgresql
If you want to create a database at container's boot time, you can set the following environment variables:
POSTGRES_DBNAME to create a databasePOSTGRES_EXTENSIONS to create extensions for the above database (only takes effect is a database is specified)On this example we will preset our custom username and password and we will create a database with a extension:
$ docker run -d \
--name postgresql \
-p 5432:5432 \
-e POSTGRES_USERNAME=myuser \
-e POSTGRES_PASSWORD=mypassword \
-e POSTGRES_DBNAME=mydb \
-e POSTGRES_EXTENSIONS=citext \
frodenas/postgresql
The PostgreSQL server is configured to store data in the /data directory inside the container. You can map the
container's /data volume to a volume on the host so the data becomes independent of the running container:
$ mkdir -p /tmp/postgresql
$ docker run -d \
--name postgresql \
-p 5432:5432 \
-v /tmp/postgresql:/data \
frodenas/postgresql
This image includes sanity-test command that can interact with a PostgreSQL service (for example, another running container of this image).
$ docker run --entrypoint '' \
-e credentials='{"uri":"postgres://user:pass@host:port/dbname"}' \
frodenas/postgresql sanity-test
You can also easily use sanity-test command to self-test a running container (note POSTGRES_DBNAME=name is required):
docker run -d --name postgresql -p 5432:5432 -e POSTGRES_DBNAME=postgres frodenas/postgresql:9.6 && \
docker exec -ti postgresql sanity-test
The output will finish with:
No $credentials provided, entering self-test mode.
Sanity testing PostgreSQL with {"hosthame":"localhost","host":"localhost","port":5432,"username":"pgadmin","password":"vD4RhsyRKq9GfAhJ","dbname":"postgres","uri":"postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres"}
Waiting for postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres to be ready (max 60s)
localhost:5432 - accepting connections
Postgres is ready
localhost:5432 - accepting connections
+ psql postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres -c 'DROP TABLE IF EXISTS sanitytest;'
NOTICE: table "sanitytest" does not exist, skipping
DROP TABLE
+ psql postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres -c 'CREATE TABLE sanitytest(value text);'
CREATE TABLE
+ psql postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres -c 'INSERT INTO sanitytest VALUES ('\''storage-test'\'');'
INSERT 0 1
+ psql postgres://pgadmin:vD4RhsyRKq9GfAhJ@localhost:5432/postgres -c 'SELECT value FROM sanitytest;'
+ grep storage-test
storage-test
If you have BOSH, with cloud config, you can deploy the image backed by a persistent disk volume managed by BOSH:
export BOSH_DEPLOYMENT=postgresql
bosh2 deploy bosh-postgresql.yml --vars-store creds.yml
To get the randomly generated PostgreSQL username, password and database name:
bosh2 int creds.yml --path /postgresql-username
bosh2 int creds.yml --path /postgresql-password
bosh2 int creds.yml --path /postgresql-dbname
Copyright (c) 2014 Ferran Rodenas. See LICENSE for details.
Content type
Image
Digest
sha256:fa00439ff…
Size
178.9 MB
Last updated
over 9 years ago
docker pull frodenas/postgresql