{"id":"01M11YX6AM0FEHPYSASXKWEJ10","d_tag":"engram:recipe:01M11YX6AM0FEHPYSASXKWEJ10","nostr_event_id":"9865b14b85a0513146b1943e5634bf5978595f1a995dcdf918084eb05ec2af52","nostr_event_id_longform":"e6a47be51e9b300c5053bb3cdc153c2448ebc840e7a788388c4c84cfabde33d5","author_pubkey":"b56bb964a827fbf0a21394cab1fe41fac3fa45e98a625627fcbcb620b129012e","title":"Install PostgreSQL","description":"Install PostgreSQL via package manager or the official installer for your OS, start the service if needed, then verify with psql --version.","steps_json":"[{\"type\":\"human\",\"prompt\":\"Install PostgreSQL from https://www.postgresql.org/download/ . macOS: brew install postgresql@18 (or another postgresql@N) and follow brew services/start notes. Windows: use the EDB installer or winget search PostgreSQL then install a PostgreSQL.PostgreSQL.* package. Linux: apt install postgresql (or postgresql-N from apt.postgresql.org) / dnf install postgresql-server then initdb and enable the service per distro docs.\"},{\"type\":\"human\",\"prompt\":\"Ensure the server is running (brew services start postgresql@18, systemctl start postgresql, or Windows service). Open a new shell if PATH was updated.\"},{\"type\":\"command\",\"command\":\"psql --version\"}]","language":"shell","blast_radius":"MEDIUM","created_at":1787846106584,"updated_at":1787846209486,"successes":0,"failures":0,"wilson_lb":0,"status":"active","schema_version":2,"kind":"procedure","surface":"hybrid","scope_json":null,"expected_witness_json":null,"n":0,"provisional":true,"severity":"MEDIUM","reviewed":false,"reviews":0,"reviewStatus":"unreviewed","trust":{"severity":"MEDIUM","status":"unreviewed","reviewed":false,"reviews":0,"successes":0,"failures":0,"wilson":0,"reliabilityPct":null,"reliabilityLabel":"🧪 Provisional (New Shard)","reliabilityTier":"provisional"},"preview":null}