2024-05-27 22:20:58 +00:00
|
|
|
|
2024-07-25 13:53:52 +00:00
|
|
|
if [ -z $POSTGRES_PASSWORD ]; then
|
|
|
|
|
echo "POSTGRES_PASSWORD was missing in env"
|
|
|
|
|
exit 5
|
|
|
|
|
fi
|
|
|
|
|
|
2024-05-27 22:20:58 +00:00
|
|
|
## drop futureporn_db
|
2024-08-17 02:42:44 +00:00
|
|
|
kubectl -n futureporn exec postgresql-primary-0 -- env PGPASSWORD=${POSTGRES_PASSWORD} psql -U postgres --command "DROP DATABASE futureporn_db WITH (FORCE);"
|
2024-07-25 13:53:52 +00:00
|
|
|
|
2024-08-17 02:42:44 +00:00
|
|
|
## drop futureporn
|
|
|
|
|
kubectl -n futureporn exec postgresql-primary-0 -- env PGPASSWORD=${POSTGRES_PASSWORD} psql -U postgres --command "DROP DATABASE futureporn WITH (FORCE);"
|
|
|
|
|
|
|
|
|
|
## delete postgrest roles
|
|
|
|
|
kubectl -n futureporn exec postgresql-primary-0 -- env PGPASSWORD=${POSTGRES_PASSWORD} psql -U postgres --command "DROP ROLE authenticator;"
|
|
|
|
|
kubectl -n futureporn exec postgresql-primary-0 -- env PGPASSWORD=${POSTGRES_PASSWORD} psql -U postgres --command "DROP ROLE automation;"
|
|
|
|
|
kubectl -n futureporn exec postgresql-primary-0 -- env PGPASSWORD=${POSTGRES_PASSWORD} psql -U postgres --command "DROP ROLE web_anon;"
|
