From a23e08ce20887efb4e158a02ffee1f775a0db89f Mon Sep 17 00:00:00 2001
From: Quentin <quentin@deuxfleurs.fr>
Date: Sat, 12 Sep 2020 20:17:07 +0200
Subject: Refactor 2

---
 app/build/postgres/Dockerfile      | 19 +++++++++++++++++++
 app/build/postgres/README.md       |  4 ++++
 app/build/postgres/postgresql.conf | 25 +++++++++++++++++++++++++
 app/build/postgres/start.sh        | 22 ++++++++++++++++++++++
 4 files changed, 70 insertions(+)
 create mode 100644 app/build/postgres/Dockerfile
 create mode 100644 app/build/postgres/README.md
 create mode 100644 app/build/postgres/postgresql.conf
 create mode 100755 app/build/postgres/start.sh

(limited to 'app/build/postgres')

diff --git a/app/build/postgres/Dockerfile b/app/build/postgres/Dockerfile
new file mode 100644
index 0000000..bb018b8
--- /dev/null
+++ b/app/build/postgres/Dockerfile
@@ -0,0 +1,19 @@
+FROM amd64/debian:stretch
+
+RUN echo "deb http://deb.debian.org/debian stretch-backports main contrib non-free # available after stretch release" > /etc/apt/sources.list.d/stretch-backports.list && \
+    apt-get update && \
+    apt-get -qq -y full-upgrade && \
+    apt-get install -y postgresql-all golang-1.11 git && \
+    export GOPATH=/usr/local/go && \
+    mkdir -p /usr/local/go/src/github.com/sorintlab && \
+    cd /usr/local/go/src/github.com/sorintlab && \
+    git clone --depth=1 https://github.com/sorintlab/stolon && \
+    ln -s /usr/lib/go-1.11/bin/go /usr/bin/go && \
+    ln -s /usr/lib/go-1.11/bin/gofmt /usr/bin/gofmt && \
+    cd ./stolon && \
+    ./build && \
+    mv /usr/local/go/src/github.com/sorintlab/stolon/bin/* /usr/local/bin/ && \
+    rm -rf /usr/local/go
+
+USER postgres
+
diff --git a/app/build/postgres/README.md b/app/build/postgres/README.md
new file mode 100644
index 0000000..d2f7a12
--- /dev/null
+++ b/app/build/postgres/README.md
@@ -0,0 +1,4 @@
+```
+docker build -t superboum/arm32v7_postgres .
+docker build -t superboum/amd64_postgres:v2 .
+```
diff --git a/app/build/postgres/postgresql.conf b/app/build/postgres/postgresql.conf
new file mode 100644
index 0000000..8e0af2b
--- /dev/null
+++ b/app/build/postgres/postgresql.conf
@@ -0,0 +1,25 @@
+data_directory = '/var/lib/postgresql/9.6/main'		# use data in another directory
+hba_file = '/etc/postgresql/9.6/main/pg_hba.conf'	# host-based authentication file
+ident_file = '/etc/postgresql/9.6/main/pg_ident.conf'	# ident configuration file
+external_pid_file = '/var/run/postgresql/9.6-main.pid'			# write an extra PID file
+listen_addresses = '*' #listen on every ip / interfaces
+port = 5432				# (change requires restart)
+max_connections = 100			# (change requires restart)
+unix_socket_directories = '/var/run/postgresql'	# comma-separated list of directories
+ssl = true				# (change requires restart)
+ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'		# (change requires restart)
+ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'		# (change requires restart)
+shared_buffers = 128MB			# min 128kB
+dynamic_shared_memory_type = posix	# the default is the first option
+log_line_prefix = '%m [%p] %q%u@%d '			# special values:
+log_timezone = 'UTC'
+cluster_name = '9.6/main'			# added to process titles if nonempty
+stats_temp_directory = '/var/run/postgresql/9.6-main.pg_stat_tmp'
+datestyle = 'iso, mdy'
+timezone = 'UTC'
+lc_messages = 'C.UTF-8'			# locale for system error message
+lc_monetary = 'C.UTF-8'			# locale for monetary formatting
+lc_numeric = 'C.UTF-8'			# locale for number formatting
+lc_time = 'C.UTF-8'				# locale for time formatting
+default_text_search_config = 'pg_catalog.english'
+
diff --git a/app/build/postgres/start.sh b/app/build/postgres/start.sh
new file mode 100755
index 0000000..f1d493f
--- /dev/null
+++ b/app/build/postgres/start.sh
@@ -0,0 +1,22 @@
+#!/bin/bash
+
+if [ -f /local/pg_hba.conf ]; then
+  echo "Copying Nomad configuration..."
+  cp /local/pg_hba.conf /etc/postgresql/9.6/main/
+  echo "Done"
+fi
+
+
+if [ -z "$(ls -A /var/lib/postgresql/9.6/main)" ]; then
+  echo "Copying base"
+  cp -r /var/lib/postgresql/9.6/base/* /var/lib/postgresql/9.6/main
+  echo "Done"
+fi
+
+chmod -R 700  /var/lib/postgresql/9.6/main
+chown -R postgres /var/lib/postgresql/9.6/main
+
+echo "Starting postgres..."
+. /usr/share/postgresql-common/init.d-functions
+start 9.6
+tail -f /var/log/postgresql/postgresql-9.6-main.log
-- 
cgit v1.2.3