Public | Automated Build

Last pushed: 3 days ago
Short Description
Spoke container for PostgreSQL, an open source SQL database.
Full Description

PostgreSQL: Open Source SQL Database

This is a Radial Wheel repository for a PostgreSQL database.

When run, the database folder and permissions are created/set and then the
database is initialized. Make note of the /config/postgresql/setupdb file.
This file contains a single string that gets sent into postgres --single at
setup for additional database commands such as assigning users, ownerships, and
any other initial database setup you might want to do.

Tunables

It has sane defaults (italics) so you can test it all out. Separate from the postgresql
configuration located in the /config/postgresql directory, the initial
database setup can be done by running with the following environment variables
set:

  • $DB_USER: {"tempuser"} Database admin user
  • $DB_PASS: [random] Password. Don't set this and a random string will
    be used
  • $DB_NAME: {"tempdb"} Database name
  • $DB_DIR: {"/data/dbdata"} Database folder location. Should be
    somewhere in the /data folder to make sure it is shared properly.
  • $SETUP_DB_COMMANDS: {"/config/postgresql/setupdb"} Path to file
    containing SQL setup commands. They must be separated by ";" and a new line,
    and all wrapped in double quotes to make it a single string. These are for
    additional user/permissions setup to the database after it is initialized.

Radial

Radial is a Docker container topology strategy that
seeks to put the canon of Docker best-practices into simple, re-usable, and
scalable images, dockerfiles, and repositories. Radial categorizes containers
into 3 types: Axles, Hubs, and Spokes. A Wheel is a repository used to recreate
an application stack consisting of any combination of all three types of
containers. Check out the Radial documentation for more.

One of the main design goals of Radial containers is simple and painless
modularity. All Spoke (application/binary) containers are designed to be run by
themselves as a service (a Wheel consisting of a Hub container for configuration
and a Spoke container for the running binary) or as part of a larger stack as a
Wheel of many Spokes all joined by the Hub container (database, application
code, web server, backend services etc.). Check out the Wheel
tutorial
for some more details on how this works.

Note also that for now, Radial makes use of Fig for all orchestration,
demonstration, and testing. Radial is just a collection of images and
strategies, so technically, any orchestration tool can work. But Fig was the
leanest and most logical to use for now.

How to Use

Static Build

In case you need to modify the entrypoint script, the Dockerfile itself, create
your "config" branch for dynamic building, or just prefer to build your own from
scratch, then you can do the following:

  1. Clone this repository
  2. Make whatever changes needed to configuration and add whatever files
  3. fig up

Dynamic Build

A standard feature of all Radial images is their ability to be used dynamically.
This means that since great care is made to separate the application code from
it's configuration, as long as you make your application configuration available
as a git repository, and in it's own "config" branch as per the guidelines in
the Wheel template, no building of any images will be
necessary at deploy time. This has many benefits as it allows rapid deployment
and configuration without any wait time in the building process. However:

Dynamic builds will not commit your configuration files into any
resulting images like static builds.

Static builds do a "COPY" of files into the image before exposing the
directories as volumes. Dynamic builds do a git fetch at run time and the
resulting data is downloaded to an already existing volume location, which is
now free from Docker versioning. Both methods have their advantages and
disadvantages. Deploying the same exact configuration might benefit from a
single image built statically whereas deploying many different disposable
configurations rapidly are best done dynamically with no building.

To run dynamically:

  1. Modify the fig-dynamic.yml file to point at your own Wheel repository
    location by setting the $WHEEL_REPO variable. When run, the Hub container
    will pull the "config" branch of that repository and use it to run the Spoke
    container with your own configuration.
  2. fig -f fig-dynamic.yml up
Docker Pull Command
Owner
radial
Source Repository