Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Magnus Hagander
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. /Magnus > --- Original Message --- > From: "Jeffrey

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
Success! First you need to make sure that the blastwave package for apache development is on your machine. Use the blastwave command: pkg-get -i apache2_devel This gives you the headers you are missing from the apache binary install (as well as loading the libtool etc that the apxs command wil

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
Using a cron task was my first thought. Unfortunately, new users are given a logon that they immediately use. I thought about shelling out and updating a password file on an on-demand basis but I am not sure if that is such a great idea either - especially since users can change their passwords a

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
Not so trivial for me as it turns out. Once I got the apxs command ironed out, I still could not compile it as I am missing all the headers in the blastwave package: apr.h apr_hooks.h apr_strings.h httpd.h and so on. Compilation aborted on me. I hope I am not looking at rebuilding from source

Re: [PERFORM] Apache2 PostgreSQL http authentication

2007-10-07 Thread Jeffrey Brower
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 sent Giuseppe an email and asked him, but I've gotten no reply. It looks like it had

Re: [PERFORM] query plan worse after analyze

2007-10-07 Thread Richard Broersma Jr
--- Stephen Frost <[EMAIL PROTECTED]> wrote: > (perhaps a > pastebin like http://pgsql.privatepaste.com) instead of or in addition > to sending it in the email. It this new? I don't remember seeing this used before. Regards, Richard Broersma Jr. ---(end of broadcast)

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