docker-compose --env-file .env.storage.local exec -T db \
bash -c "pg_restore -U postgres -d tep5_production --clean --no-owner --if-exists" < \
<(gunzip -c tep5_production_20250801_181138.dump.gz)
docker-compose --env-file .env.storage.local exec db \
psql -U postgres -d tep5_production -c '\dt'
List of relations
Schema | Name | Type | Owner
--------+--------------------------------------------+-------+----------
public | accounts | table | postgres
public | active_storage_attachments | table | postgres
public | active_storage_blobs | table | postgres
public | active_storage_variant_records | table | postgres
public | ar_internal_metadata | table | postgres
public | bankbooks | table | postgres
public | categories | table | postgres
public | clients | table | postgres
public | descriptions | table | postgres
public | fam_client_district_class | table | postgres
public | fam_others_client_district_class | table | postgres
public | fam_others_client_district_class_kai_addr | table | postgres
public | fam_others_client_district_class_kai_addr2 | table | postgres
public | familymembers | table | postgres
public | familymembers3 | table | postgres
public | holidays | table | postgres
public | journals | table | postgres
public | kaimyous | table | postgres
public | lists | table | postgres
public | notes | table | postgres
public | others | table | postgres
public | places | table | postgres
public | places_cp | table | postgres
public | places_flag_false | table | postgres
public | places_flag_true | table | postgres
public | places_multi_flag_false_no_multi | table | postgres
public | posts | table | postgres
public | relationship_categories | table | postgres
public | relationships | table | postgres
public | schedules | table | postgres
public | schema_migrations | table | postgres
public | temp4_even | table | postgres
public | temp4_odd | table | postgres
public | users | table | postgres
(34 rows)