Postgresql
From wikinotes
Official documentation: https://www.postgresql.org/docs/manuals/
Quick Reference | |
---|---|
psql -h 192.168.1.217 -p 5432 -U root test_database |
cli tool |
5432 |
default port |
/var/db/postgres/data96/postgresql.conf |
primary config |
/var/db/postgres/data96/pg_hba.conf |
network config |
Documentation
official docs https://www.postgresql.org/docs/9.3/index.html postgres common mistakes https://wiki.postgresql.org/wiki/Don%27t_Do_This postgres: high availability https://www.postgresql.org/docs/current/high-availability.html postgres permissions/workflows https://marcyes.com/2016/0922-messing-with-postgresql-users-and-permissions/
Usage
postgresql install postgresql configuration postgresql usage postgresql syntax postgresql plpg syntax
Architecture
postgresql high availability