Commit 4e11911

Eric Bower  ·  2026-05-10 21:22:24 -0400 EDT
parent 07d445f
docs: runbooks
1 files changed,  +21, -0
A runbooks/delete-account.md
+21, -0
 1@@ -0,0 +1,21 @@
 2+# How to delete user with all data
 3+
 4+Log into production db, then drop into psql
 5+
 6+```bash
 7+cd pico
 8+make psql
 9+```
10+
11+```sql
12+delete from app_users where name = 'xxx';
13+```
14+
15+This only removes data from the database, we also have static assets (prose images, pgs assets).
16+
17+We have a clean bucket script for prose and pgs that we run periodically to remove static assets from orphaned buckets.
18+
19+```bash
20+make scripts
21+FS_STORAGE_DIR="./data/storage" go run ./cmd/scripts/clean-buckets
22+```