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

자세한 정보

평가판, 구매 및 판매

커뮤니티

Red Hat 문서 정보

보다 포괄적 수용을 위한 오픈 소스 용어 교체

Red Hat 소개

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links