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