summaryrefslogtreecommitdiffstats
path: root/Services/postgres/sx
diff options
context:
space:
mode:
Diffstat (limited to 'Services/postgres/sx')
-rw-r--r--Services/postgres/sx/postgresql.sh66
-rw-r--r--Services/postgres/sx/postgresql_run.sh7
2 files changed, 0 insertions, 73 deletions
diff --git a/Services/postgres/sx/postgresql.sh b/Services/postgres/sx/postgresql.sh
deleted file mode 100644
index 7b57905..0000000
--- a/Services/postgres/sx/postgresql.sh
+++ /dev/null
@@ -1,66 +0,0 @@
-#!/bin/bash
-export TERM=dumb
-
-# Begin configuration before starting daemonized process
-# and start generating host keys
-function begin_config {
- echo "=> Begin postgresql configuration for host $HOSTNAME"
- postgresql-setup initdb
- postgresql-setup upgrade
- start_server
- update_rootuser
-}
-
-# End configuration process just before starting daemon
-function end_config {
- stop_server
- echo "=> End postgresql configuration ..."
-}
-
-# Start the postgresql server in background. Used to perform config
-# against the database structure such as user creation
-function start_server {
- echo "===> Starting postgresql server ..."
- /usr/bin/postgres
-}
-
-# Stop the postgresql server running in background.
-function stop_server {
- echo "===> Stopping postgresql server ..."
- killall postgres
-}
-
-# Set new root password and grant permissions to all databases
-function update_rootuser {
- if [ "$pgsql_newadminpwd" = "" ]; then
- export pgsql_newadminpwd=$(pwgen 13 1);
- fi
- local n=$pgsql_newadminpwd;
- echo "===> Update root user password and permission"
- sudo -u postgres psql -U postgres -d postgres -c "alter user postgres with password '$pgsql_newadminpwd';"
- unset pgsql_newadminpwd;
- export PGSQL_ROOTPWD=$n;
- echo "========================================================================";
- echo "You can now connect to this PostgresQL Server using the following credentials:";
- echo " ";
- echo " user type : administrator";
- echo " username : postgres";
- echo " password : $n";
- echo " ";
- echo " psql -h <host> -p <port> --username=postgres; $n";
- echo "========================================================================";
- echo " ";
- return 0
-}
-
-# Start the postgresql server as a deamon and execute it inside
-# the running shell
-function start_daemon {
- echo "=> Starting postgresql daemon ..."
- exec /usr/bin/postgres -D /var/lib/pgsql/data -c config_file=/var/lib/pgsql/postgresql.conf
-}
-
-
-if [[ "$0" == *"postgresql.sh" && ! $1 = "" ]];then
- eval "$@";
-fi \ No newline at end of file
diff --git a/Services/postgres/sx/postgresql_run.sh b/Services/postgres/sx/postgresql_run.sh
deleted file mode 100644
index 9504ff5..0000000
--- a/Services/postgres/sx/postgresql_run.sh
+++ /dev/null
@@ -1,7 +0,0 @@
-#!/bin/bash
-source /sx/postgresql.sh
-
-begin_config
-end_config
-
-start_daemon \ No newline at end of file