3.4. Configuring PostgreSQL

You can configure PostgreSQL by editing the configuration files in the database cluster directory to set database parameters, authentication, and client access. By default, PostgreSQL uses the /var/lib/pgsql/data/ directory.

/var/lib/pgsql/data/postgresql.conf - is used for setting the database cluster parameters.
/var/lib/pgsql/data/postgresql.auto.conf - holds basic PostgreSQL settings similarly to postgresql.conf. However, this file is under the server’s control. It is edited by the ALTER SYSTEM queries, and cannot be edited manually.
/var/lib/pgsql/data/pg_ident.conf - is used for mapping user identities from external authentication mechanisms into the PostgreSQL user identities.
/var/lib/pgsql/data/pg_hba.conf - is used for configuring client authentication for PostgreSQL databases.

Procedure

Edit the /var/lib/pgsql/data/postgresql.conf file and configure basic settings of the database cluster parameters, for example:

log_connections = yes
log_destination = 'syslog'
search_path = '"$user", public'
shared_buffers = 128MB
password_encryption = scram-sha-256

Edit the /var/lib/pgsql/data/pg_hba.conf file and configure client authentication, for example:

# TYPE    DATABASE       USER        ADDRESS              METHOD
local     all            all                              trust
host      postgres       all         192.168.93.0/24      ident
host      all            all         .example.com         scram-sha-256

Restart the postgresql service so that the changes become effective:
```
# systemctl restart postgresql.service
```

3.4. Configuring PostgreSQL

学习

尝试、购买和销售

社区

关于红帽文档

让开源更具包容性

關於紅帽

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links