Re: graceful reload

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vasiliy G Tolstov wrote:
In config file some in of this settings exists comment line like
"changes require restart". This is mean exactly restart or reload can do
this?

Run this:

$ psql -c "select name,context from pg_settings"

This will sort out which settings are in which category definitively, rather than relying on the sometimes ambiguous comments in the file. Settings that say "postmaster" require a full database restart. Ones labeled "sighup" can be changed in the postgresql.conf and then the server signaled to use them, most easily with:

pg_ctl reload
-OR-
psql -c "select pg_reload_conf()"

Ones labeled "user" you can actually change for any user at any time during their session. Modifying the defaults and then executing the sighup procedure will make those new defaults active, but not for any clients that already have open connections.

I recommend using SHOW or looking at pg_settings after making a change and reloading the server config to confirm it took.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@xxxxxxxxxxxxxxx   www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux