Here is a perl script I use for vacuuming. It's
in my postgres crontab, so that it runs with the
proper environment variables. There's probably
a more elegant solution, but this works okay for
me.
--Keith
[EMAIL PROTECTED]
#!/usr/bin/p
The same thing happens to me running mod_perl with Apache
and PostgreSQL. I've kept the resources down by lowering
MinSpareServers, MaxSpareServers, and ...uh, I forget the
setting, but it's for number of clients accepted before a
child server dies (MaxClients, maybe?). But, I also
don't run a m
Lamar Owen wrote:
> [snip]
> > 2) how do i schedule a regular vacuum through cron? do you not have to be
> > in psql to do a vacuum? or can you do it from the bash prompt? (we are
> > using linux rh 5.2, kernel 2.2.2, postgres 6.4.2)
>
> Again, my crontab (sub your database name for "intran
