Postgresql common configuration files are the postgresql.conf and pg_hba.conf. In many cases, its possible to edit without the need to restart the database. Here are the 2 options on Centos Linux;
Use systemctl
# systemctl reload postgresql-11
or
# systemctl reload postgresql
Within Postgresql
Login and and access psql as admin or user postgres then run this sql.
SELECT pg_reload_conf();
No comments:
Post a Comment