Alvaro Herrera wrote: > Obviously he wants a tool that allows setting parameters from a shell > script or something for use within pg_autotune. I don't see why it is > bad to have a tool to do this; if someone can use it (and modify > postgresql.conf) obviously he has permission to read (and write) > postgresql.conf. >
But, if that's the case, why not just: 1. send e.g. "set sort_mem=8192" as an SQL statement for runtime changeable parameters 2. use e.g. "pg_ctl restart -D $PGDATA -o '--shared_buffers=10000'" for those parameters requiring a restart Joe ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org