diff options
| author | Eden <edendeoliveira@gmail.com> | 2019-04-10 23:02:55 +0100 |
|---|---|---|
| committer | Eden <edendeoliveira@gmail.com> | 2019-04-10 23:12:09 +0100 |
| commit | fdc231661647d4ca15ddf312e85b210eabd23e50 (patch) | |
| tree | 36a1e267f434b3e5c6bafe9a57b0abf4fd82236e /tools/postgresql.html | |
| parent | 675126cad1cde96a6fcf63efdc1bd8b6f6ba22ad (diff) | |
| parent | a19f7c5f9f357102b469b2b44c3f0749e1345b11 (diff) | |
| download | doc-fdc231661647d4ca15ddf312e85b210eabd23e50.tar.gz | |
doc release 0.5.2
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> |