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```