Advertising:

Reload pg hba.conf sin reiniciar Postgres

From Zabbix-ES
Revision as of 06:56, 10 June 2020 by Unknown user (talk) (Created page with " - Entramos como postgres # su - postgres - Actualizamos el pg_hba.conf $ vi /var/lib/pgsql/12/data/pg_hba.conf - Refrescamos la configuracion del pg_hba.conf $ pg_ctl...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
- Entramos como postgres
# su - postgres
- Actualizamos el pg_hba.conf
$ vi /var/lib/pgsql/12/data/pg_hba.conf
- Refrescamos la configuracion del pg_hba.conf
$ pg_ctl reload -D /var/lib/pgsql/12/data        <- Envía una señal -1 para que el proceso se releea

$ psql -U postgres -c "select pg_reload_conf();" <- Internamente Postgres relee la configuración