Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 10/29/2015 01:35 PM, Jim Longwill wrote: >> ... I'm always getting this error: >> ERROR: parameter "autovacuum" cannot be changed now > Controls whether the server should run the autovacuum launcher > daemon. This is on by default; however, track_counts must also be > enabled for autovacuum to work. SEE--> This parameter can only be set in > the postgresql.conf file or on the server command line. <---SEE Yeah, this is more or less what I feared Jim would run into, though I'd forgotten the details. "autovacuum" actually controls whether the launcher is started at all, and so it cannot be set on a per-database basis. I believe it might work to adjust many of the other autovac parameters at the per-database level, but not that one. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
