From: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What the heck is happening here? |
Date: | 2001-06-11 21:44:45 |
Message-ID: | 20010611174445.A24564@allhats.xcski.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Quoting Alex Pilosov (alex(at)pilosoft(dot)com):
> In mod_perl case, make sure that your stuff does not try to establish
> connections on startup, and only does that (using ApacheDBI to cache
> connections) when the page is requested.
Oh oh. I *am* doing that - I make a connection to grab some stuff right
at start up, and keep that $conn for all the pages. Is there a good
example of using ApacheDBI to cache connections using Pg.pm I can look at?
> Also, it is possible that every day some script tries to rotate logs and
> SIGHUPs the httpd. mod_perl may do strange stuff on restart. Try manually
> sending HUP to server and see what happens.
Actually, sending HUP to all the httpd processes is the only thing that
fixes it. For a while.
--
Paul Tomblin <ptomblin(at)xcski(dot)com>, not speaking for anybody
Courtroom Quotes
Q: Were you alone or by yourself?
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Barnard | 2001-06-11 21:46:44 | Re: Odd behavior with LIKE? |
Previous Message | Konstantin Borchert | 2001-06-11 21:38:05 | Monitoring PostgreSQL |