{"architecture":"amd64","config":{"Hostname":"","Domainname":"","User":"","AttachStdin":false,"AttachStdout":false,"AttachStderr":false,"Tty":false,"OpenStdin":false,"StdinOnce":false,"Env":["PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin","BUILD_PATH=/var/src/pgsql","PSQL_USER=postgres","PSQL_DATABASE=postgres","LD_LIBRARY_PATH=/usr/local/gdal/gdal_deps/freexl/lib:/usr/local/gdal/gdal_deps/PROJ4/lib:/usr/local/gdal/gdal_deps/libtiff/lib:/usr/local/gdal/gdal_deps/openjpeg/lib:/usr/local/gdal/gdal_deps/lz4/lib:/usr/local/gdal/gdal_deps/zstd/lib:/usr/local/gdal/gdal_deps/laszip/lib:/usr/local/lib:/lib:/usr/local/gdal/gdal_deps:/usr/local/gdal/gdal_deps/cgal:/usr/local/gdal/gdal_deps/sfcgal:/usr/local/gdal/gdal_deps/armadillo/lib:/usr/local/gdal/gdal_deps/lapack/lib:/usr/local/gdal/gdal_deps/odbc/lib:/usr/local/gdal/gdal_deps/unixODBC/lib:/usr/local/gdal/gdal_deps/libgeotiff/lib:/usr/local/gdal/lib"],"Cmd":["/entrypoint.sh"],"Image":"sha256:62549bd535befeae111163c137d47b3295645899578877a499a700bcf9c2bf1c","Volumes":null,"WorkingDir":"","Entrypoint":null,"OnBuild":null,"Labels":null},"container":"3e3da5debadcfa20c6e37c0de1e17d96deeee2c2c21d909180f0730a0f2220ee","container_config":{"Hostname":"3e3da5debadc","Domainname":"","User":"","AttachStdin":false,"AttachStdout":false,"AttachStderr":false,"Tty":false,"OpenStdin":false,"StdinOnce":false,"Env":["PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin","BUILD_PATH=/var/src/pgsql","PSQL_USER=postgres","PSQL_DATABASE=postgres","LD_LIBRARY_PATH=/usr/local/gdal/gdal_deps/freexl/lib:/usr/local/gdal/gdal_deps/PROJ4/lib:/usr/local/gdal/gdal_deps/libtiff/lib:/usr/local/gdal/gdal_deps/openjpeg/lib:/usr/local/gdal/gdal_deps/lz4/lib:/usr/local/gdal/gdal_deps/zstd/lib:/usr/local/gdal/gdal_deps/laszip/lib:/usr/local/lib:/lib:/usr/local/gdal/gdal_deps:/usr/local/gdal/gdal_deps/cgal:/usr/local/gdal/gdal_deps/sfcgal:/usr/local/gdal/gdal_deps/armadillo/lib:/usr/local/gdal/gdal_deps/lapack/lib:/usr/local/gdal/gdal_deps/odbc/lib:/usr/local/gdal/gdal_deps/unixODBC/lib:/usr/local/gdal/gdal_deps/libgeotiff/lib:/usr/local/gdal/lib"],"Cmd":["/bin/sh","-c","#(nop) ","CMD [\"/entrypoint.sh\"]"],"Image":"sha256:62549bd535befeae111163c137d47b3295645899578877a499a700bcf9c2bf1c","Volumes":null,"WorkingDir":"","Entrypoint":null,"OnBuild":null,"Labels":{}},"created":"2022-04-21T12:42:17.348749475Z","docker_version":"20.10.7","history":[{"created":"2020-12-11T02:08:58.665097692Z","created_by":"/bin/sh -c #(nop) ADD file:f03e68a10b84e2342cfffbb8cdec1117c7f5e5d0dd004072e84efb62cfdf157c in / "},{"created":"2020-12-11T02:08:58.90376076Z","created_by":"/bin/sh -c #(nop) CMD [\"bash\"]","empty_layer":true},{"created":"2020-12-17T08:42:27.497435829Z","created_by":"/bin/sh -c #(nop) ARG comp_cores=","empty_layer":true},{"created":"2020-12-17T08:42:27.627246491Z","created_by":"/bin/sh -c #(nop) ARG PSQL_USER=postgres","empty_layer":true},{"created":"2020-12-17T08:42:27.746517665Z","created_by":"/bin/sh -c #(nop) ARG PSQL_PASSWD=pg","empty_layer":true},{"created":"2020-12-17T08:42:27.88093274Z","created_by":"/bin/sh -c #(nop) ARG PSQL_DATABASE=postgres","empty_layer":true},{"created":"2022-04-21T11:18:34.229897017Z","created_by":"/bin/sh -c #(nop) ENV BUILD_PATH=/var/src/pgsql PSQL_USER=postgres PSQL_DATABASE=postgres LD_LIBRARY_PATH=/usr/local/gdal/gdal_deps/freexl/lib:/usr/local/gdal/gdal_deps/PROJ4/lib:/usr/local/gdal/gdal_deps/libtiff/lib:/usr/local/gdal/gdal_deps/openjpeg/lib:/usr/local/gdal/gdal_deps/lz4/lib:/usr/local/gdal/gdal_deps/zstd/lib:/usr/local/gdal/gdal_deps/laszip/lib:/usr/local/lib:/lib:/usr/local/gdal/gdal_deps:/usr/local/gdal/gdal_deps/cgal:/usr/local/gdal/gdal_deps/sfcgal:/usr/local/gdal/gdal_deps/armadillo/lib:/usr/local/gdal/gdal_deps/lapack/lib:/usr/local/gdal/gdal_deps/odbc/lib:/usr/local/gdal/gdal_deps/unixODBC/lib:/usr/local/gdal/gdal_deps/libgeotiff/lib:/usr/local/gdal/lib","empty_layer":true},{"created":"2022-04-21T11:18:37.167380657Z","created_by":"/bin/sh -c #(nop) COPY dir:c4dc75971f12b84f6fc0db5e766a8b3cb5bcecca64c5f64af45a0b0c7da82bd4 in /usr/local/gdal/ "},{"created":"2022-04-21T11:18:37.863953718Z","created_by":"/bin/sh -c #(nop) COPY dir:6f345c3e1a4bccb68ac903300941c6f0bc0236531fd58b6f255174e5b798efb8 in /home/static/ "},{"created":"2022-04-21T12:42:15.304126549Z","created_by":"|2 PSQL_PASSWD=pg comp_cores= /bin/sh -c apt-get update \u0026\u0026 apt-get install libexpat1-dev libcurl4-gnutls-dev libspatialite-dev libpq-dev libpng-dev libjpeg-dev ocl-icd-opencl-dev locales autoconf procps bc python3-pip wget libtool curl nano sudo -y \u0026\u0026 cp /home/static/postgresql /etc/init.d/ \u0026\u0026 cp /home/static/postgresStart.sh /home/ \u0026\u0026 mkdir -p $BUILD_PATH \u0026\u0026 cp /home/static/Makefile $BUILD_PATH \u0026\u0026 cp /home/static/entrypoint.sh / \u0026\u0026 printf \"${PSQL_PASSWD}\\n${PSQL_PASSWD}\\n\\n\\n\\n\\n\\nY\\n\" | adduser ${PSQL_USER} \u0026\u0026 apt-get update \u0026\u0026 apt-get -y install git flex bison libreadline6-dev zlib1g-dev libossp-uuid-dev \u0026\u0026 mkdir -p /home/Downloads \u0026\u0026 cd /home/Downloads \u0026\u0026 wget https://ftp.postgresql.org/pub/source/v11.2/postgresql-11.2.tar.gz \u0026\u0026 tar -xzf postgresql-11.2.tar.gz \u0026\u0026 cd /home/Downloads/postgresql-11.2 \u0026\u0026 ./configure --prefix=/usr/local/pgsql --with-ossp-uuid \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 export PATH=/usr/local/pgsql/bin:$PATH \u0026\u0026 export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH \u0026\u0026 ldconfig \u0026\u0026 printf \"1\\n\" | dpkg-reconfigure locales \u0026\u0026 cd /home/Downloads/postgresql-11.2/contrib/uuid-ossp \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 chown -R ${PSQL_USER}:${PSQL_USER} /usr/local/pgsql \u0026\u0026 chmod +x /etc/init.d/postgresql \u0026\u0026 cd /usr/local/pgsql \u0026\u0026 echo \"${PSQL_PASSWD}\" \u003e\u003e /tmp/admin_pass \u0026\u0026 echo \"*:*:*:${PSQL_USER}:${PSQL_PASSWD}\" \u003e\u003e /.pgpass \u0026\u0026 chmod 600 /.pgpass \u0026\u0026 chown postgres:postgres /.pgpass \u0026\u0026 su -c \"bin/initdb --pgdata=/usr/local/pgsql/${PSQL_DATABASE} --pwfile=/tmp/admin_pass --auth=md5 --username=${PSQL_USER} --encoding=UTF8 \" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#listen_addresses = .*/listen_addresses='*'/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#port = .*/port=5432/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"echo \\\"host all all 0.0.0.0/0 md5\\\" \u003e\u003e /usr/local/pgsql/${PSQL_DATABASE}/pg_hba.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#random_page_cost = .*/random_page_cost = 2.0/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 SHARED_BUFFER_MEMORY=$(echo $(free --mega | sed -nE \"s/^Mem: *([0-9]*).*/\\\\1/p\")*0.25 | bc | xargs printf '%.0f') \u0026\u0026 EFFECTIVE_CACHE_MEMORY=$(echo $(free --mega | sed -nE \"s/^Mem: *([0-9]*).*/\\\\1/p\")*0.5 | bc | xargs printf '%.0f') \u0026\u0026 su -c \"sed -i -E \\\"s/#?shared_buffers = .*/shared_buffers='${SHARED_BUFFER_MEMORY}MB' # Changed /g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#?wal_buffers = .*/wal_buffers=256MB # Changed/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#?effective_cache_size = .*/effective_cache_size='${EFFECTIVE_CACHE_MEMORY}MB' # Changed/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#?work_mem = .*/work_mem=256MB # Changed/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 su -c \"sed -i -E \\\"s/#?maintenance_work_mem = .*/maintenance_work_mem=1024MB # Changed/g\\\" /usr/local/pgsql/${PSQL_DATABASE}/postgresql.conf\" ${PSQL_USER} \u0026\u0026 cd /etc/init.d \u0026\u0026 sed -i -E 's\u0026PG_DATA_DIR=\"\\$\\{PG_INSTALL_DIR\\}/data\"\u0026PG_DATA_DIR=\"/usr/local/pgsql/'${PSQL_DATABASE}'\"\u0026g' /etc/init.d/postgresql \u0026\u0026 sed -i -E 's\u0026PG_UNIX_USER=postgres\u0026PG_UNIX_USER='${PSQL_USER}'\u0026g' /etc/init.d/postgresql \u0026\u0026 apt-get -y install expect \u0026\u0026 chmod +x /home/postgresStart.sh \u0026\u0026 cp /home/static/check_ext.sql /usr/local/pgsql/check_ext.sql \u0026\u0026 touch /usr/local/pgsql/serverlog \u0026\u0026 cd /home/Downloads \u0026\u0026 wget https://github.com/protocolbuffers/protobuf/releases/download/v3.14.0/protobuf-all-3.14.0.tar.gz \u0026\u0026 tar -xvzf protobuf-all-3.14.0.tar.gz \u0026\u0026 cd protobuf-3.14.0 \u0026\u0026 ./autogen.sh \u0026\u0026 ./configure \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd /home/Downloads \u0026\u0026 curl -OL https://github.com/protobuf-c/protobuf-c/releases/download/v1.3.3/protobuf-c-1.3.3.tar.gz \u0026\u0026 tar -xvzf protobuf-c-1.3.3.tar.gz \u0026\u0026 cd protobuf-c-1.3.3 \u0026\u0026 ./configure \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd /home/Downloads \u0026\u0026 rm -r /home/Downloads/protobuf-3.14.0 /home/Downloads/protobuf-c-1.3.3 \u0026\u0026 apt-get update \u0026\u0026 apt-get install -y xsltproc imagemagick dblatex libxml2-dev libcunit1 libcunit1-doc libcunit1-dev libjson-c-dev libpcre3-dev git libboost-all-dev libcgal-dev libmpfr-dev libgmp3-dev \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/GEOS/lib/libgeos_c.so.1 /usr/local/pgsql/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/PROJ4/lib/libproj.so.15 /usr/local/pgsql/lib/ \u0026\u0026 ln -s /usr/local/gdal/lib/libgdal.so.20 /usr/local/pgsql/lib/ \u0026\u0026 ln -s /usr/local/gdal/lib/libgdal.so.20 /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/armadillo/lib/libarmadillo.so /usr/local/lib/libarmadillo.so.9 \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/zstd/lib/libzstd.so.1 /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/sfcgal/lib/libSFCGAL.so.1 /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/cgal/lib/libCGAL.so.13 /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/cgal/lib/libCGAL_Core.so.13 /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/libNCSEcw.so.5.4.0 /usr/local/lib/libNCSEcw.so \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/libNCSEcw.so.5.4.0 /usr/local/lib/libNCSEcw.so.5.4.0 \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/libjvm.so /usr/local/lib \u0026\u0026 ln -s /usr/local/gdal/gdal_deps/freexl/lib/libfreexl.so /usr/local/lib \u0026\u0026 ldconfig \u0026\u0026 cd /home/Downloads \u0026\u0026 wget https://download.osgeo.org/postgis/source/postgis-2.5.2.tar.gz \u0026\u0026 tar -xzf postgis-2.5.2.tar.gz \u0026\u0026 cd /home/Downloads/postgis-2.5.2 \u0026\u0026 ./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config --with-geosconfig=/usr/local/gdal/gdal_deps/GEOS/bin/geos-config --with-projdir=/usr/local/gdal/gdal_deps/PROJ4 --with-gdalconfig=/usr/local/gdal/bin/gdal-config --with-sfcgal=/usr/local/gdal/gdal_deps/sfcgal/bin/sfcgal-config \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd /home/Downloads/postgresql-11.2/contrib \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd /home/Downloads/postgis-2.5.2/extensions \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads/postgis-2.5.2/extensions/address_standardizer \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads/ \u0026\u0026 wget https://launchpad.net/ubuntu/+archive/primary/+sourcefiles/pgsql-ogr-fdw/1.0.7-2/pgsql-ogr-fdw_1.0.7.orig.tar.gz \u0026\u0026 tar -xvf pgsql-ogr-fdw_1.0.7.orig.tar.gz \u0026\u0026 cd /home/Downloads/pgsql-ogr-fdw-1.0.7 \u0026\u0026 export PATH=/usr/local/gdal/bin:/usr/local/pgsql/bin:$PATH \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads/ \u0026\u0026 git clone https://github.com/EnterpriseDB/pldebugger \u0026\u0026 cd pldebugger \u0026\u0026 export USE_PGXS=1 \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads/ \u0026\u0026 wget https://github.com/pramsey/pgsql-http/archive/master.zip \u0026\u0026 unzip master.zip \u0026\u0026 cd pgsql-http-master/ \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads \u0026\u0026 wget https://github.com/pgpointcloud/pointcloud/archive/master.zip \u0026\u0026 unzip master.zip.1 \u0026\u0026 cd pointcloud-master \u0026\u0026 ./autogen.sh \u0026\u0026 ./configure --prefix=/usr/local/pointcloud_pgsql \u0026\u0026 make \u0026\u0026 make install \u0026\u0026 cd /home/Downloads \u0026\u0026 wget http://api.pgxn.org/dist/multicorn/1.4.0/multicorn-1.4.0.zip \u0026\u0026 unzip multicorn-1.4.0.zip \u0026\u0026 cd multicorn-1.4.0 \u0026\u0026 export PATH=/usr/local/pgsql/bin:$PATH \u0026\u0026 export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH \u0026\u0026 cd /home/Downloads/multicorn-1.4.0 \u0026\u0026 PYTHON_OVERRIDE=python3 make install \u0026\u0026 pip3 install gdata-python3 oauth2client gspread pyasn1-modules \u0026\u0026 cd /home/Downloads \u0026\u0026 git clone https://github.com/lincolnturner/gspreadsheet_fdw.git \u0026\u0026 cd /home/Downloads/gspreadsheet_fdw \u0026\u0026 python3 setup.py install \u0026\u0026 export TZ='Europe/Madrid' \u0026\u0026 mkdir -p /home/pg_home \u0026\u0026 mv /home/static/googleSpreadSheetAuth.json /home/pg_home/ipsilum.json \u0026\u0026 chown ${PSQL_USER}:${PSQL_USER} /home/pg_home/ipsilum.json \u0026\u0026 chmod go-rwx /home/pg_home/ipsilum.json \u0026\u0026 cd /home/Downloads \u0026\u0026 wget -O pgrouting-3.0.0.tar.gz https://github.com/pgRouting/pgrouting/archive/v3.0.0.tar.gz \u0026\u0026 tar xvfz pgrouting-3.0.0.tar.gz \u0026\u0026 cd pgrouting-3.0.0 \u0026\u0026 mkdir build \u0026\u0026 apt-get install cmake -y \u0026\u0026 cd build \u0026\u0026 cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/pgrouting -DPOSTGRESQL_PG_CONFIG=/usr/local/pgsql/bin/pg_config \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 export PATH=/usr/local/pgsql/bin:$PATH \u0026\u0026 export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH \u0026\u0026 apt-get update \u0026\u0026 apt-get install clang-format lcov doxygen -y \u0026\u0026 cd /home/Downloads \u0026\u0026 git clone https://github.com/uber/h3.git \u0026\u0026 cd h3 \u0026\u0026 git checkout tags/v3.6.4 \u0026\u0026 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/h3 -DCMAKE_C_FLAGS=\"-fPIC\" . \u0026\u0026 make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd .. \u0026\u0026 rm -r h3 \u0026\u0026 export PATH=/usr/local/h3/bin:$PATH \u0026\u0026 export PATH=/usr/local/h3/bin:$PATH \u0026\u0026 export LD_LIBRARY_PATH=/usr/local/h3/lib:$LD_LIBRARY_PATH \u0026\u0026 cd /home/Downloads \u0026\u0026 git clone https://github.com/dlr-eoc/pgh3.git \u0026\u0026 cd pgh3 \u0026\u0026 git checkout tags/v0.3.0 \u0026\u0026 CFLAGS=\"-L/usr/local/h3/lib -I/usr/local/h3/include\" make -j ${comp_cores} \u0026\u0026 make -j ${comp_cores} install \u0026\u0026 cd .. \u0026\u0026 rm -r pgh3 \u0026\u0026 /home/postgresStart.sh \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION postgis;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION adminpack;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION address_standardizer;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION dblink;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION file_fdw;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION ogr_fdw;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pg_prewarm;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pldbgapi;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION \\\\\\\"uuid-ossp\\\\\\\";\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION postgis_sfcgal;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION postgres_fdw;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pg_trgm;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION http;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pointcloud;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pgcrypto;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION fuzzystrmatch;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION postgis_tiger_geocoder;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION postgis_topology;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION multicorn;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pgrouting;\\\"\" ${PSQL_USER} \u0026\u0026 su -c \"PGPASSFILE=/.pgpass /usr/local/pgsql/bin/psql -U ${PSQL_USER} -d postgres -c \\\"CREATE EXTENSION pgh3;\\\"\" ${PSQL_USER} \u0026\u0026 rm -r /home/Downloads /home/static \u0026\u0026 apt-get clean \u0026\u0026 apt-get autoclean"},{"created":"2022-04-21T12:42:17.348749475Z","created_by":"/bin/sh -c #(nop) CMD [\"/entrypoint.sh\"]","empty_layer":true}],"os":"linux","rootfs":{"type":"layers","diff_ids":["sha256:e4b1e8d0745b9e73ccd05f1654c2dcd7806a841d65e083c32cc09259aad57da3","sha256:f5d791e46e2824374b84ea13f61b6e315df626430512453035414e87ce40cfd9","sha256:72659dc390c83dc61b091994038a938b48bc09fe9e69addebcece9c0a4fff9e9","sha256:f30516afa6cd424f89827c79719ddd887c4db6be1e7f92c0d8df1a2869627b0e"]}}