-
-
Save leylaKapi/68061cc87a13de36ce6728fd4c4b1d31 to your computer and use it in GitHub Desktop.
Downgrade PostgreSQL on Semaphore
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash -l | |
set -e | |
### | |
# Add the line below to your setup command in Project Settings | |
# | |
# wget https://gist.githubusercontent.com/mimimalizam/27959bbc653de3965bb40955f4bc43df/raw/pg-downgrade-semaphore.sh && bash pg-downgrade-semaphore.sh | |
# | |
# Note: reset your dependency cache in Project Settings > Admin, before running this script | |
### | |
pg_version=${1:-'9.4'} | |
echo "--------------------------------------------" | |
echo "# Installing PostgreSQL version: $pg_version" | |
echo "--------------------------------------------" | |
install-package --update libpq5 postgresql-client-$pg_version postgresql-$pg_version postgresql-contrib-$pg_version postgresql-server-dev-$pg_version libpq-dev postgresql-$pg_version-postgis-2.2 | |
echo 'allow_system_table_mods = on' | sudo tee -a /etc/postgresql/10/main/postgresql.conf | |
sudo service postgresql restart | |
echo "Creating postgres user" | |
sudo su postgres <<CMD | |
declare -x PGCLUSTER="9.4/main" | |
psql -c "ALTER USER postgres" -d template1; | |
psql -c "CREATE USER runner WITH PASSWORD 'semaphoredb';" -d template1; | |
psql -c "ALTER USER runner CREATEUSER CREATEDB;" -d template1; | |
psql -c "CREATE EXTENSION hstore WITH SCHEMA pg_catalog;" -d template1; | |
CMD | |
export PGCLUSTER="9.4/main" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment