Re: What the heck is happening here?

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?

In response to

Responses

Browse pgsql-general by date

  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