4 pkg_cmd_name="postgres"
7 POSTGRES_DATA_DIR=$HOME/.local/share/postgres/var
9 pkg_get_current_version() {
10 # 'postgres --version' has output in this format:
11 # postgres (PostgreSQL) 10.13
12 # This trims it down to just the version number:
14 echo "$(postgres --version 2>/dev/null | head -n 1 | cut -d' ' -f3)"
18 # mkdir -p $HOME/.local/opt
19 mkdir -p "$(dirname $pkg_src)"
21 # mv ./pgqsl* "$HOME/.local/opt/postgres-v10.13"
26 # rm -f "$HOME/.local/opt/postgres"
28 rm -f "$HOME/Applications/pgAdmin"*.app || true
30 # ln -s "$HOME/.local/opt/postgres-v10.13" "$HOME/.local/opt/postgres"
31 ln -s "$pkg_src" "$pkg_dst"
32 ln -s "$pkg_src/pgAdmin 4.app" "$HOME/Applications/pgAdmin 4.app" || true
36 webi_path_add "$pkg_dst_bin"
38 #echo "Initializing PostgreSQL with database at $POSTGRES_DATA_DIR/"
40 PWFILE="$(pwd)/pwfile.tmp"
41 mkdir -p "$POSTGRES_DATA_DIR"
42 chmod 0700 "$POSTGRES_DATA_DIR"
44 if [ ! -f "$POSTGRES_DATA_DIR/postgresql.conf" ]; then
45 echo "postgres" > "$PWFILE"
46 "$pkg_src/bin/initdb" \
47 -D "$POSTGRES_DATA_DIR/" \
48 --username postgres --pwfile "$PWFILE" \
49 --auth-local=password --auth-host=password
54 # TODO show with serviceman
55 echo "Installed 'postgres' and 'psql' at $pkg_dst"
59 echo "Database initialized at $POSTGRES_DATA_DIR:"
60 echo " postgres -D $POSTGRES_DATA_DIR -p 5432"
62 echo "Username and password set to 'postgres':"
63 echo " psql 'postgres://postgres:postgres@localhost:5432/postgres'"