Skip to content

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