В Чтв, 03/06/2010 в 13:07 -0400, Greg Smith пишет: > 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. > Ok, Thank You very much! This is really helpful. -- Vasiliy G Tolstov <v.tolstov@xxxxxxxxx> Selfip.Ru -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
