diff options
| author | Silvino Silva <silvino@bk.ru> | 2019-03-06 21:19:54 +0000 |
|---|---|---|
| committer | Silvino Silva <silvino@bk.ru> | 2019-03-06 21:19:54 +0000 |
| commit | 1203067a4e33c9ca6897dfa40a13a80454a40220 (patch) | |
| tree | 1d987ef5208f894fe0afa54374a7aee3603f2cf3 /tools/postgresql.html | |
| parent | 89710a657c8a5226272e0d17e1693a44365a1641 (diff) | |
| download | doc-1203067a4e33c9ca6897dfa40a13a80454a40220.tar.gz | |
postgresql revision
Diffstat (limited to 'tools/postgresql.html')
| -rw-r--r-- | tools/postgresql.html | 28 |
1 files changed, 9 insertions, 19 deletions
diff --git a/tools/postgresql.html b/tools/postgresql.html index 00fe1ae..285e7c3 100644 --- a/tools/postgresql.html +++ b/tools/postgresql.html @@ -141,7 +141,7 @@ ssl_key_file = '/etc/ssl/keys/pg.key' # (change requires restart) #ssl_ca_file = '' # (change requires restart) #ssl_crl_file = '' # (change requires restart) - password_encryption = on + password_encryption = scram-sha-256 </pre> <h3>2.5. Configure pg_hba.conf</h3> @@ -152,20 +152,10 @@ <pre> # TYPE DATABASE USER ADDRESS METHOD - - # "local" is for Unix domain socket connections only - #local all all trust - local all postgres ident - # IPv4 local connections: - host all all 127.0.0.1/32 trust - #hostssl all all 192.168.0.0/32 md5 - # IPv6 local connections: - #host all all ::1/128 trust - # Allow replication connections from localhost, by a user with the - # replication privilege. - #local replication postgres trust - #host replication postgres 127.0.0.1/32 trust - #host replication postgres ::1/128 trust + local postgres all trust + host postgres all 127.0.0.1/32 trust + host all all 127.0.0.1/32 scram-sha-256 + host all all 0.0.0.0/0 reject </pre> <p>Start server and alter postgres password</p> @@ -189,9 +179,10 @@ syslog_facility='LOCAL0' syslog_ident='postgres' log_connections = on + log_disconnections = on + log_duration = on </pre> - <p>Create /etc/logrotate.d/postgres;</p> <pre> @@ -300,7 +291,7 @@ db_flyspray=# create schema public; </pre> - <h2 id="backup">8. Backup</h3> + <h2 id="backup">8. Backup and restore</h3> <h3>8.1. Dump databases</h3> @@ -317,10 +308,9 @@ <a href="index.html">Tools Index</a> <p> This is part of the Hive System Documentation. - Copyright (C) 2018 + Copyright (C) 2019 Hive Team. See the file <a href="../fdl-1.3-standalone.html">Gnu Free Documentation License</a> for copying conditions.</p> - </body> </html> |