chore: ban ip runbook - pico@4902f05

Commit `4902f05`

Eric Bower · 2026-07-17 09:47:08 -0400 EDT

parent e87f1c0

chore: ban ip runbook

1 files changed, +16, -0

A runbooks/ban-ip.md

+16, -0

......@@ -0,0 +1,16 @@
# How to ban an ip address from creating an account

You also need to [delete the original account](./delete-account.md) because blocking ip only works for the signup flow in our TUI.

Log into production db, then drop into psql

```bash
cd pico
make psql
```

```sql
insert into block_signups (ip, reason) values ('0.0.0.0', 'you spam too much');
```

The IP column is an [inet data type](https://www.postgresql.org/docs/current/datatype-net-types.html#DATATYPE-INET) to enforce correct structure.

...	...		@@ -0,0 +1,16 @@
	1	+	# How to ban an ip address from creating an account
	2	+
	3	+	You also need to [delete the original account](./delete-account.md) because blocking ip only works for the signup flow in our TUI.
	4	+
	5	+	Log into production db, then drop into psql
	6	+
	7	+	```bash
	8	+	cd pico
	9	+	make psql
	10	+	```
	11	+
	12	+	```sql
	13	+	insert into block_signups (ip, reason) values ('0.0.0.0', 'you spam too much');
	14	+	```
	15	+
	16	+	The IP column is an [inet data type](https://www.postgresql.org/docs/current/datatype-net-types.html#DATATYPE-INET) to enforce correct structure.

Commit 4902f05

Commit `4902f05`