8 lines
465 B
Bash
Executable File
8 lines
465 B
Bash
Executable File
#!/usr/bin/bash
|
|
HOST="deployment.rehearsal.alpinesmuseum.ungleich.cloud"
|
|
cd ~/Desktop/ungleich/alpinesmuseum
|
|
ssh app@$HOST "pg_dump -f `date "+%Y-%m-%d".sql`"; scp app@$HOST:/home/app/`date "+%Y-%m-%d".sql` .
|
|
echo "SELECT 'DROP TABLE IF EXISTS \"' || tablename || '\" CASCADE;' FROM pg_tables WHERE schemaname = 'public';" | psql -f - -t -d alpines -U app | psql -f - -d alpines -U app
|
|
psql -U app -d alpines -f `date "+%Y-%m-%d".sql`
|
|
rm -rf `date "+%Y-%m-%d".sql`
|