PostgreSQL 配置
约 1 分钟阅读
标签:配置
# 使用 socket 连接 - 如果配置了 pg_hba.conf local 则不需要密码
psql -h /var/run/postgresql -U postgres -d postgres
# root -> postgres
su -l postgres -s /bin/bash
# SIGHUP 重载配置
pg_ctl reload -D /var/lib/postgresql/data/pgdata- /var/run/postgresql/
- .s.PGSQL.5432
SELECT pg_reload_conf();- Server Configuration
- jberkus/annotated.confGitHubjberkus/annotated.conf
- pgtune.leopard.in.ua
- pgpedia.info
- postgresqlco.nf/doc/en/param
SSL
- libpq-ssl
- Secure TCP/IP Connections with SSL
- 需要配置 hba 来强制 ssl
关联信息
反向链接和本文引用的外部资料。
References
GitHub
1 条- jberkus/annotated.confgithub.com/jberkus/annotated.conf
其他外链
6 条- pgpedia.infopgpedia.info/
- pgtune.leopard.in.uapgtune.leopard.in.ua/
- postgresqlco.nf/doc/en/parampostgresqlco.nf/doc/en/param
- www.postgresql.org/docs/current/libpq-ssl.htmlwww.postgresql.org/docs/current/libpq-ssl.html
- www.postgresql.org/docs/current/runtime-config.htmlwww.postgresql.org/docs/current/runtime-config.html
- www.postgresql.org/docs/current/ssl-tcp.htmlwww.postgresql.org/docs/current/ssl-tcp.html