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. Source Tutorial
2. http://www.postgresqltutorial.com/
3. https://www.postgresguide.com/tips/dates/
4. Cheatsheet - https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546

---

Last update: May 7, 2023