PostgreSQL

1. Installation (local)
2. Cheatsheet - DB/Table Metrics
3. Cheatsheet - DB Troubleshooting
4. Concepts

Configure to start automatically

$ mkdir -p ~/Library/LaunchAgents
$ ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
$ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

Note: if not installed via homebrew, it should looks like com.postgresapp.Postgres2LoginHelper.plist

References

1. Postgres - Json functions | Official docs
2. Safe and unsafe operations for high volume PostgreSQL
3. Source Tutorial
4. http://www.postgresqltutorial.com/
5. Postgres Guide - tips on dates
6. Cheatsheet - https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546

---

Last update: May 6, 2024