Myron's Dev Notes

• home
• db

---

Postgres Notes

• https://www.postgresql.org/
• https://www.postgresql.org/docs/10/index.html
• https://github.com/dhamaniasad/awesome-postgres

Start/Stop MacOS service

sudo -i
su - postgres
cd /Library/PostgreSQL/9.6/bin/
./pg_ctl -D /Library/PostgreSQL/9.6/data stop -s -m fast # stop
./pg_ctl -D /Library/PostgreSQL/9.6/data -l /Library/PostgreSQL/9.6/data/pg_log/postgresql-server.log start
launchctl remove com.edb.launchd.postgresql-9.6

Environment Variables

• https://www.postgresql.org/docs/current/libpq-envars.html

  export PGPASSWORD=xxx
  

Links

• https://github.com/dhamaniasad/awesome-postgres