How to use createdb and not fail when using custom postgres?

This troubleshooting guide describes the solution when using custom postgresql, createdb fails as ‘local user with ID 1001 does not exist’

Problem

unknown.png

Solution

  1. Execute the command as an user postgres instead, e.g., createdb -U postgres chirpns
Last modified October 5, 2022: Historian article (#107) (5f30dc0)