I usually use pg_ctl reload instead of kill On Thu, 27 Jan 2005 14:57:22 -0800, Lonni J Friedman wrote > Is there any way to increase sort_mem without having to perform a > full restart of the DB? Will just doing a 'kill -HUP $PID" work as > long as i've made the change in postgresql.conf first? > > As a side question, are the options that will take effect with a kill > -HUP documented somewhere? > > thanks! > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > L. Friedman netllama@xxxxxxxxx > LlamaLand http://netllama.linux-sxs.org > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx -- Jonel Rienton http://blogs.road14.com Software Developer, *nix Advocate ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
