Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread Alvaro Herrera
Magnus Hagander wrote:
> 2009/8/27 Alvaro Herrera :
> > Magnus Hagander wrote:
> >
> >> It'd be kind of neat of majordomo could insert a "held for moderation
> >> at " and "released from moderation at " headers or
> >> something. Anybody know if that's possible to do?
> >
> > You'd need to get Marc to patch the Majordomo2 source code ...
> > I proposed a patch months ago to have message-ids expanded in the
> > message footer, but no luck.
> 
> Did you cook up an actual patch? The majordomo server actually is
> something that the community has access to... (it's not properly
> documented, of course, but it's there)

Of course; attached.

I have not tried a patch for the feature you propose.  It'd be good to
have those (and also an indication of which moderator approved the
message).

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
diff -cr majordomo/lib/Mj/Resend.pm majordomo.orig/lib/Mj/Resend.pm
*** majordomo/lib/Mj/Resend.pm	2007-10-31 16:27:46.0 -0300
--- majordomo.orig/lib/Mj/Resend.pm	2009-03-17 12:06:32.0 -0400
***
*** 707,712 
--- 707,713 
   'SUBJECT'=> $subject || '(no subject)',
   'SUBSCRIBED' => ($avars{'days_since_subscribe'} < 0) ? "not" : "",
   'USER'   => "$user",
+  'MESSAGE_ID' => $msgid,
};
  
if ($mode !~ /archive/) {

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread Magnus Hagander
2009/8/27 Alvaro Herrera :
> Magnus Hagander wrote:
>
>> It'd be kind of neat of majordomo could insert a "held for moderation
>> at " and "released from moderation at " headers or
>> something. Anybody know if that's possible to do?
>
> You'd need to get Marc to patch the Majordomo2 source code ...
> I proposed a patch months ago to have message-ids expanded in the
> message footer, but no luck.

Did you cook up an actual patch? The majordomo server actually is
something that the community has access to... (it's not properly
documented, of course, but it's there)


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread Alvaro Herrera
Magnus Hagander wrote:

> It'd be kind of neat of majordomo could insert a "held for moderation
> at " and "released from moderation at " headers or
> something. Anybody know if that's possible to do?

You'd need to get Marc to patch the Majordomo2 source code ...
I proposed a patch months ago to have message-ids expanded in the
message footer, but no luck.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread Magnus Hagander
2009/8/27 Alvaro Herrera :
> Greg Stark wrote:
>> Now why did this message get delayed by 4 hours before maia-1
>> delivered it to me? That was long enough in this to completely lose
>> the thread of conversation.
>>
>> Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
>>       by maia-1.hub.org (Postfix) with ESMTP id 2909CAFD073;
>>       Thu, 27 Aug 2009 03:21:19 + (UTC)
>> Received: from localhost (unknown [200.46.208.211])
>>       by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486D
>>       for ; Wed, 26 Aug 2009
>> 20:52:17 -0300 (ADT)
>
> Moderator delay?  I note that the message jumped to me from mx2.hub.org
> instead of maia-1, but at exactly the same time (down to seconds) -- but
> at a different time zone.

Quite likely. It's often not possible to see the difference between
moderation delay and mailsystem breakage delay, without looking at the
logfiles.

It'd be kind of neat of majordomo could insert a "held for moderation
at " and "released from moderation at " headers or
something. Anybody know if that's possible to do?

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread Alvaro Herrera
Greg Stark wrote:
> Now why did this message get delayed by 4 hours before maia-1
> delivered it to me? That was long enough in this to completely lose
> the thread of conversation.
> 
> Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
>   by maia-1.hub.org (Postfix) with ESMTP id 2909CAFD073;
>   Thu, 27 Aug 2009 03:21:19 + (UTC)
> Received: from localhost (unknown [200.46.208.211])
>   by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486D
>   for ; Wed, 26 Aug 2009
> 20:52:17 -0300 (ADT)

Moderator delay?  I note that the message jumped to me from mx2.hub.org
instead of maia-1, but at exactly the same time (down to seconds) -- but
at a different time zone.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-26 Thread Greg Stark
Now why did this message get delayed by 4 hours before maia-1
delivered it to me? That was long enough in this to completely lose
the thread of conversation.

Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
by maia-1.hub.org (Postfix) with ESMTP id 2909CAFD073;
Thu, 27 Aug 2009 03:21:19 + (UTC)
Received: from localhost (unknown [200.46.208.211])
by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486D
for ; Wed, 26 Aug 2009
20:52:17 -0300 (ADT)



-- 
greg
http://mit.edu/~gsstark/resume.pdf

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers