Let user choose extension to enable or upgrade

[submarcos]

According

#265
#187
#191 (comment)
#263

I'd like to try to let user choose their own (available) extensions in environment variables.

I can propose:

ENV POSTGRES_EXTENSIONS fuzzystrmatch
ENV POSTGIS_EXTENSIONS postgis postgis_topology postgis_tiger_geocoder

initdb

# Load extensions into both template_database and $POSTGRES_DB
for DB in template_postgis "$POSTGRES_DB"; do
    echo "Loading PostGIS extensions into $DB"

    for EXTENSION in $POSTGIS_EXTENSIONS; do
	  	"${psql[@]}" --dbname="$DB" -c "CREATE EXTENSION IF NOT EXISTS $EXTENSION";
    done

    echo "Loading Postgres extensions into $DB"

    for EXTENSION in $POSTGRES_EXTENSIONS; do
  	  "${psql[@]}" --dbname="$DB" -c "CREATE EXTENSION IF NOT EXISTS $EXTENSION";
   done
done

updatedb

# Load PostGIS into both template_database and $POSTGRES_DB
for DB in template_postgis "$POSTGRES_DB" "${@}"; do
    echo "Updating PostGIS extensions '$DB' to $POSTGIS_VERSION"

    for EXTENSION in $POSTGIS_EXTENSIONS; do
    	"${psql[@]}" --dbname="$DB" -c "
    	        CREATE EXTENSION IF NOT EXISTS $EXTENSION";
    	        ALTER EXTENSION $EXTENSION UPDATE TO '$POSTGIS_VERSION';
    done

    echo "Create other postgres extensions in '$DB'"

    for EXTENSION in $POSTGRES_EXTENSIONS; do
      	"${psql[@]}" --dbname="$DB" -c "CREATE EXTENSION IF NOT EXISTS $EXTENSION";
    done
done

With this I am able to run :

docker run -e POSTGRES_PASSWORD=password -e POSTGRES_EXTENSIONS="unaccent" -e POSTGIS_EXTENSIONS="postgis postgis_raster" -it my_local_image

I choose to separate POSGTRES and POSTGIS extensions because only POSTGIS's should be upgraded

We can change environment variable names

What are you thinking about for a first shoot ?