>
> 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
>
i set up the following script to run at 5am daily:
touch /var/log/imgonnadoit.at5
su svmaster
psql serviceworks -c 'vacuum;'
exit
touch /var/log/ididit.at5
i had planned to ls -l /var/log/i* to see the times of imgonnadoit.at5 and
ididit.at5 to see if the span looked reasonable -- and therefore
On Tue, 13 Jul 1999, JT Kirkpatrick wrote:
> i set up the following script to run at 5am daily:
>
> touch /var/log/imgonnadoit.at5
> su svmaster
> psql serviceworks -c 'vacuum;'
> exit
> touch /var/log/ididit.at5
>
> i had planned to ls -l /var/log/i* to see the times of imgonnadoit.at5 and
> i
I'm sorry, but I believe you I misconveyed my dilemma. It is postgres
which is running away with too many processes - not Apache. What would
lowering MinSpareServers (etc) do to help that?
Paul
Keith Keller wrote:
>
> The same thing happens to me running mod_perl with Apache
> and PostgreSQL.
At 16:55 +0300 on 13/07/1999, PAUL J THOMPSON wrote:
> I'm sorry, but I believe you I misconveyed my dilemma. It is postgres
> which is running away with too many processes - not Apache. What would
> lowering MinSpareServers (etc) do to help that?
Let's try to attack this problem: Where do you
Hi!
Can anyone help me with this?
When trying to perform a query it threw : " ERROR: cannot write block
113 of pg_log "
I searched through all the digests and documentation and found nothing.
I've tried vacuuming the base, removing file pg_log, but didn't work.
Any ideas?
Thanks a lot,
Ok. I have a class called QuizData which maintains all database
connections. An instance of this class is created by a servlet each time
it runs the doGet() method. In the finalize method of the QuizData
class, I have something like:
if (isOpen()) {
db.close;
}
is
Hello everybody,
We are using postgres at Fermi lab since long. But we have not been able to
successfully install it on one of our red hat machine recently after a lots of
efforts. The OS is Red Hat linux release 5.2(
Appollo), kernal: 2.0.36 (on i686). The installation procedure does not co
I want to create a user that can do SELECTs on existing tables.
This is easy I just do the proper GRANTS. The problem is I also
want to restrict that user from creating tables in the database.
In other words this user should be able to read but not write to
anything at all. Other users will be
