From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, Michael Nacos <m(dot)nacos(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Overhauling GUCS |
Date: | 2008-08-19 08:09:41 |
Message-ID: | 48AA7FC5.6070800@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Alvaro Herrera wrote:
> Tom Lane escribió:
>> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>>> The entire target market for such a thing is DBAs stuck on hosted databases
>>> which don't have shell access to their machines. Perhaps the overlap between
>>> that and the people who can write a server-side module which dumps out a
>>> config file according to some rules is just too small?
>> There's a veritable boatload of stuff we do that assumes shell access
>> (how many times have you seen cron jobs recommended, for instance?).
>> So I'm unconvinced that "modify the config without shell access"
>> is really a goal that is worth lots of effort.
>
> Actually, lots of people are discouraged by suggestions of using cron to
> do anything. The only reason cron is suggested is because we don't have
> any other answer, and for many people it's a half-solution. An
> integrated task scheduler in Pg would be more than welcome.
Yes, I hear a lot of people complaining aobut that too. Now that we have
a working autovacuum, some of it goes away though - no need to cron your
VACUUMs in most cases anymore. But there are still backups - but they
are often managed by the scheduler of an enterprise backup software.
> Also, remember that pgAdmin already comes with a pgAgent thing.
Yeah, it's a real life-saver on Windows where the builtin task-scheduler
isn't as readily accessible or easy to use..
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-08-19 08:11:09 | Re: Extending varlena |
Previous Message | Tatsuo Ishii | 2008-08-19 07:49:55 | Re: [HACKERS] WITH RECURSIVE patches 0818 |