| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Justin Clift <justin(at)postgresql(dot)org>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_config : postgresql.conf adjustments? |
| Date: | 2002-09-29 17:55:02 |
| Message-ID: | 3D973E76.40700@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-09-29 18:08:37 | Re: pg_config : postgresql.conf adjustments? |
| Previous Message | Hannu Krosing | 2002-09-29 17:29:32 | Re: DROP COLUMN misbehaviour with multiple inheritance |