| 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: | Whole Thread | Raw Message | 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 |