Zdenek Kotala wrote:

I like this idea. By my opinion only GUC variable with PGC_POSTMASTER context must be in postgresql.conf. Most of them are related to memory and networking configuration. Other can be only store in database. And for startup, default value will work pretty well.

By the way, why postgresql.conf is required for startup when I'm able setup all parameter on command line?


You aren't able to.

postgres=# set shared_buffers = '32768';
ERROR:  parameter "shared_buffers" cannot be changed after server start
STATEMENT:  set shared_buffers = '32768';
ERROR:  parameter "shared_buffers" cannot be changed after server start
postgres=#


Joshua D. Drake


        Zdenek



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to