Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-08 Thread Tino Wildenhain
Magnus Hagander schrieb: I'd consider having a small daemon LISTENing for NOTIFYs that you send by triggers whenever the table has changed. That'll make sure it only dumps if something actually changed. And you can also implement some ratelimiting if needed. Do you really think such a homegro

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-08 Thread Magnus Hagander
Tino Wildenhain wrote: > Magnus Hagander schrieb: >> I'd consider having a small daemon LISTENing for NOTIFYs that you send >> by triggers whenever the table has changed. That'll make sure it only >> dumps if something actually changed. And you can also implement some >> ratelimiting if needed. > D

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Magnus Hagander
-- > From: "Jeffrey Brower" <[EMAIL PROTECTED]> > To: "'D'Arcy J.M. Cain'" <[EMAIL PROTECTED]> > Sent: 07-10-07, 22:58:29 > Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication > > Using a cron task was my first thought. Unfo

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
iginal Message- From: Jeffrey Brower [mailto:[EMAIL PROTECTED] Sent: Sunday, October 07, 2007 4:29 PM To: [EMAIL PROTECTED]; pgsql-performance@postgresql.org Subject: RE: [PERFORM] Apache2 PostgreSQL http authentication Not so trivial for me as it turns out. Once I got the apxs command

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
and renew their logons at will as well. Jeff -Original Message- From: D'Arcy J.M. Cain [mailto:[EMAIL PROTECTED] Sent: Sunday, October 07, 2007 4:45 PM To: [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication On S

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread D'Arcy J.M. Cain
On Sun, 7 Oct 2007 09:14:43 -0400 "Jeffrey Brower" <[EMAIL PROTECTED]> wrote: > As I say, from a performance point of view, I would really like to know if > there is anything I can do to make sure that postgres is performing as > quickly as possible under apache2 so that my http authentication is n

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
-performance@postgresql.org Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication Thanks for the reply! I have used this in the past on Linux systems with Apache 1 - but I had no idea if the Apache2 version would compile under Solaris (let alone the Solaris X86 version) and run dependably. I

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
pgsql-performance@postgresql.org Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication On Oct 7, 2007, at 9:14 , Jeffrey Brower wrote: > Greetings All, > > I have to authenticate against an existing (constantly modified) > PostgreSQL database under Solaris 10 (X86). While my PHP

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread A.M.
On Oct 7, 2007, at 9:14 , Jeffrey Brower wrote: Greetings All, I have to authenticate against an existing (constantly modified) PostgreSQL database under Solaris 10 (X86). While my PHP scripts are an obvious no-brainer, the rest of the contents need to be protected as well (images, etc

[PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
Greetings All, I have to authenticate against an existing (constantly modified) PostgreSQL database under Solaris 10 (X86). While my PHP scripts are an obvious no-brainer, the rest of the contents need to be protected as well (images, etc) so the http authentication is required. I am using the