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