postgres joins the fight

[webi-installers/.git] / postgres / install.sh

diff --git a/postgres/install.sh b/postgres/install.sh
new file mode 100644 (file)
index 0000000..c21cdb7
--- /dev/null
+++ b/postgres/install.sh
@@ -0,0 +1,66 @@
+set -e
+set -u
+
+pkg_cmd_name="postgres"
+#WEBI_SINGLE=""
+
+POSTGRES_DATA_DIR=$HOME/.local/share/postgres/var
+
+pkg_get_current_version() {
+    # 'postgres --version' has output in this format:
+    #       postgres (PostgreSQL) 10.13
+    # This trims it down to just the version number:
+    #       10.13
+    echo "$(postgres --version 2>/dev/null | head -n 1 | cut -d' ' -f3)"
+}
+
+pkg_install() {
+    # mkdir -p $HOME/.local/opt
+    mkdir -p "$(dirname $pkg_src)"
+
+    # mv ./pgqsl* "$HOME/.local/opt/postgres-v10.13"
+    mv ./"p"* "$pkg_src"
+}
+
+pkg_link() {
+    # rm -f "$HOME/.local/opt/postgres"
+    rm -f "$pkg_dst"
+    rm -f "$HOME/Applications/pgAdmin*.app" || true
+
+    # ln -s "$HOME/.local/opt/postgres-v10.13" "$HOME/.local/opt/postgres"
+    ln -s "$pkg_src" "$pkg_dst"
+    ln -s "$pkg_src/pgAdmin 4.app" "$HOME/Applications/pgAdmin 4.app" || true
+}
+
+pkg_post_install() {
+    webi_path_add "$pkg_dst_bin"
+
+    #echo "Initializing PostgreSQL with database at $POSTGRES_DATA_DIR/"
+
+    PWFILE="$(pwd)/pwfile.tmp"
+    mkdir -p "$POSTGRES_DATA_DIR"
+    chmod 0700 "$POSTGRES_DATA_DIR"
+
+    if [ ! -f "$POSTGRES_DATA_DIR/postgresql.conf" ]; then
+      echo "postgres" > "$PWFILE"
+      "$pkg_src/bin/initdb" \
+        -D "$POSTGRES_DATA_DIR/" \
+        --username postgres --pwfile "$PWFILE" \
+        --auth-local=password --auth-host=password
+    fi
+}
+
+pkg_done_message() {
+    # TODO show with serviceman
+    echo "Installed 'postgres' and 'psql' at $pkg_dst"
+    echo ""
+    echo "IMPORTANT!!!"
+    echo ""
+    echo "Database initialized at $POSTGRES_DATA_DIR:"
+    echo "    postgres -D $POSTGRES_DATA_DIR -p 5432"
+    echo ""
+    echo "Username and password set to 'postgres':"
+    echo "    psql 'postgres://postgres:postgres@localhost:5432/postgres'"
+    echo ""
+}
+