mv all via vps

# Copy uploads
ssh {{wps_1}} 'cd /home/{{user}}/{{user}}/{{user}}/server/app/ && tar czf - uploads/' | ssh {{wps_2}} 'sudo tar xvzf - -C /home/{{user}}/{{user}}/{{user}}/server/app/'


# Copy locale
ssh {{wps_1}} 'cd /home/{{user}}/{{user}}/{{user}}/server/app/ && tar czf - locale/' | ssh {{wps_2}} 'sudo tar xvzf - -C /home/{{user}}/{{user}}/{{user}}/server/app/'

# Copy via ssh
# --- remote to local
ssh host 'cat /path/on/remote' > /path/on/local
# --- local to remote
cat /path/on/local | ssh host 'cat > /path/on/remote'
# --- remote to remote
ssh host1 'cat /path/on/host1' | ssh host2 'cat > /path/on/host2'

# Dump DB
# if for vps
cd /home/{{user}}/ && sudo -u postgres pg_dump {{user}}_db > ./{{user}}_dump.sql
# if for local
cd /home/{{user}}/ && sudo -u postgres pg_dump {{user}}_db --clean > ./{{user}}_dump.sql


# Copy DB dump
ssh {{wps_1}} 'cat /home/{{user}}/{{user}}_dump.sql' | ssh {{wps_2}} 'sudo tee -a /home/{{user}}/{{user}}_dump.sql >/dev/null'

# Apply local in docker
docker exec -i {{user}}_db psql -U postgres -d db < {{user}}_dump.sql

# Apply DB dump
cd /home/{{user}}/
sudo su postgres
psql
DROP DATABASE {{user}}_db;
CREATE DATABASE {{user}}_db ENCODING 'UTF-8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' OWNER {{user}}_db TEMPLATE template0;
psql {{user}}_db < {{user}}_dump.sql


# Change tables owner
for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" {{user}}_db` ; do  psql -c "alter table $tbl owner to {{user}}" {{user}}_db ; done


# Fix owner permissions
GRANT usage ON schema public TO public;
GRANT CREATE ON schema public TO public;
psql {{user}}_db -c "GRANT ALL ON ALL TABLES IN SCHEMA public to {{user}}_db;"
psql {{user}}_db -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to {{user}}_db;"
psql {{user}}_db -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to {{user}}_db;"