# Tools and Lambdas for Datafy



# Dump Remote

## PostGres
pg_dump -h aws-0-eu-central-1.pooler.supabase.com -p 6543 -d postgres -U postgres.natpyffafbqetnbeoctm -F c -b -v -f /tmp/remote_db_backup.dump

## Supabase - Schema
npx supabase db dump -f schema.sql
## Supabase - Data
npx supabase db dump --data-only -f schema_data.sql

# Restore local
## PostGres - Schema
psql -h localhost -p 54322 -U postgres -d postgres -a -f schema.sql 
## PostGres - Data
psql -h localhost -p 54322 -U postgres -d postgres -a -f schema_data.sql