Обсуждение: Sending the beta4 release announcement, don't approve until the links are live!
Sending the beta4 release announcement, don't approve until the links are live!
От
Selena Deckelmann
Дата:
Beta4 dirs aren't there yet. I'm assuming Devrim or someone else can approve when they are ready? -selena -- http://chesnok.com/daily - me
On 1 August 2010 18:29, Selena Deckelmann <selenamarie@gmail.com> wrote: > Beta4 dirs aren't there yet. I'm assuming Devrim or someone else can > approve when they are ready? > > -selena > > -- > http://chesnok.com/daily - me > > -- Looks like this message got stuck in the system for 3 days :S -- Thom Brown Registered Linux user: #516935
Re: Sending the beta4 release announcement, don't approve until the links are live!
От
Robert Haas
Дата:
On Wed, Aug 4, 2010 at 6:50 AM, Thom Brown <thom@linux.com> wrote: > On 1 August 2010 18:29, Selena Deckelmann <selenamarie@gmail.com> wrote: >> Beta4 dirs aren't there yet. I'm assuming Devrim or someone else can >> approve when they are ready? > > Looks like this message got stuck in the system for 3 days :S I just saw a stalled -committers post pop out, too. Not sure if they were waiting for moderation or what. It seems to me that in the future we might be better off arranging for the people who approve release announcements to have moderator access, and then have them not send the email until it's time for it to go out, and approve it themselves. There seem to be a variety of ways that the current system can go wrong. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Greg Sabino Mullane"
Дата:
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Marc, can you shed any light on this delay? It was rather an important one. > Received: from postgresql.org (mail.postgresql.org [200.46.204.86]) > by mx2.hub.org (Postfix) with ESMTP id 764C13F00D81; > Wed, 4 Aug 2010 07:48:10 -0300 (ADT) > > Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) > by mail.postgresql.org (Postfix) with ESMTP id 98C2263298E > for <pgsql-www-postgresql.org@mail.postgresql.org>; > Sun, 1 Aug 2010 14:29:44 -0300 (ADT) - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 201008041012 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkxZdUkACgkQvJuQZxSWSsiEeQCgxyma7FA7wN4SvXFb01JzxJ/u XgEAoOT3DNl7pXwvR1HEE71IjzkIVkNe =RkZq -----END PGP SIGNATURE-----
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Alvaro Herrera
Дата:
Excerpts from Greg Sabino Mullane's message of mié ago 04 14:13:19 UTC 2010: > Marc, can you shed any light on this delay? It was rather an > important one. relevant headers: Received: from postgresql.org (mail.postgresql.org [200.46.204.86]) by mx2.hub.org (Postfix) with ESMTP id 764C13F00D81; Wed, 4 Aug 2010 07:48:10 -0300 (ADT)Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org(Postfix) with ESMTP id 98C2263298E for <pgsql-www-postgresql.org@mail.postgresql.org>; Sun, 1 Aug2010 14:29:44 -0300 (ADT) Seems it was stuck in the guts of maia.hub.org for no particular reason. If this episode is not a good reason to decouple postgresql.org from Hub.org, I don't know what is. -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Seems it was stuck in the guts of maia.hub.org for no particular reason.
It looked like moderation delay to me, especially since a whole bunch of
stuff got approved at once.
regards, tom lane
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Marc G. Fournier"
Дата:
On Wed, 4 Aug 2010, Alvaro Herrera wrote: > Excerpts from Greg Sabino Mullane's message of mi? ago 04 14:13:19 UTC 2010: > >> Marc, can you shed any light on this delay? It was rather an >> important one. > > relevant headers: > > Received: from postgresql.org (mail.postgresql.org [200.46.204.86]) > by mx2.hub.org (Postfix) with ESMTP id 764C13F00D81; > Wed, 4 Aug 2010 07:48:10 -0300 (ADT) > Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) > by mail.postgresql.org (Postfix) with ESMTP id 98C2263298E > for <pgsql-www-postgresql.org@mail.postgresql.org>; Sun, 1 Aug 2010 14:29:44 -0300 (ADT) > > Seems it was stuck in the guts of maia.hub.org for no particular reason. Apparently you can't read headers? :) Aug 1st - maia passes email to mail.postgresql.org Aug 4th - mail.postgresql.org passes email to mx2.hub.org Intervening time: stuck in majordomo moderator queue ... ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Alvaro Herrera
Дата:
Excerpts from Marc G. Fournier's message of mié ago 04 10:44:39 -0400 2010: > Apparently you can't read headers? :) > > Aug 1st - maia passes email to mail.postgresql.org > Aug 4th - mail.postgresql.org passes email to mx2.hub.org > > Intervening time: stuck in majordomo moderator queue ... Doh. Weren't we supposed to pass through unmoderated all emails coming from addresses subscribed to any of the lists? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Marc G. Fournier"
Дата:
On Wed, 4 Aug 2010, Alvaro Herrera wrote: > Excerpts from Marc G. Fournier's message of mi? ago 04 10:44:39 -0400 2010: > >> Apparently you can't read headers? :) >> >> Aug 1st - maia passes email to mail.postgresql.org >> Aug 4th - mail.postgresql.org passes email to mx2.hub.org >> >> Intervening time: stuck in majordomo moderator queue ... > > Doh. > > Weren't we supposed to pass through unmoderated all emails coming from > addresses subscribed to any of the lists? Since I didn't approve it, I'm not sure why it got hung up ... I know we've had issues where some ppls mailers have been pushing the 'header limits', such that we've rcently increased the limit again ... But, again, not sure why it was held ... ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Robert Haas
Дата:
On Wed, Aug 4, 2010 at 11:40 AM, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Excerpts from Marc G. Fournier's message of mié ago 04 10:44:39 -0400 2010: > >> Apparently you can't read headers? :) >> >> Aug 1st - maia passes email to mail.postgresql.org >> Aug 4th - mail.postgresql.org passes email to mx2.hub.org >> >> Intervening time: stuck in majordomo moderator queue ... > > Doh. > > Weren't we supposed to pass through unmoderated all emails coming from > addresses subscribed to any of the lists? Probably not on -announce. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Alvaro Herrera
Дата:
Excerpts from Robert Haas's message of mié ago 04 12:43:29 -0400 2010: > On Wed, Aug 4, 2010 at 11:40 AM, Alvaro Herrera > <alvherre@commandprompt.com> wrote: > > Excerpts from Marc G. Fournier's message of mié ago 04 10:44:39 -0400 2010: > > > >> Apparently you can't read headers? :) > >> > >> Aug 1st - maia passes email to mail.postgresql.org > >> Aug 4th - mail.postgresql.org passes email to mx2.hub.org > >> > >> Intervening time: stuck in majordomo moderator queue ... > > > > Doh. > > > > Weren't we supposed to pass through unmoderated all emails coming from > > addresses subscribed to any of the lists? > > Probably not on -announce. This was on pgsql-www. -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Robert Haas
Дата:
On Wed, Aug 4, 2010 at 12:47 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Excerpts from Robert Haas's message of mié ago 04 12:43:29 -0400 2010: >> On Wed, Aug 4, 2010 at 11:40 AM, Alvaro Herrera >> <alvherre@commandprompt.com> wrote: >> > Excerpts from Marc G. Fournier's message of mié ago 04 10:44:39 -0400 2010: >> > >> >> Apparently you can't read headers? :) >> >> >> >> Aug 1st - maia passes email to mail.postgresql.org >> >> Aug 4th - mail.postgresql.org passes email to mx2.hub.org >> >> >> >> Intervening time: stuck in majordomo moderator queue ... >> > >> > Doh. >> > >> > Weren't we supposed to pass through unmoderated all emails coming from >> > addresses subscribed to any of the lists? >> >> Probably not on -announce. > > This was on pgsql-www. Oh. Right. In that case, I agree with you. :-) -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Magnus Hagander
Дата:
<p>That was me. It was raining, and clearly people hadn't kept up with moderation :)<p>/Magnus<br /><p>On Aug 4, 2010 4:37PM, "Tom Lane" <<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>> wrote:<br type="attribution" />> AlvaroHerrera <<a href="mailto:alvherre@commandprompt.com">alvherre@commandprompt.com</a>> writes:<br /> >> Seemsit was stuck in the guts of <a href="http://maia.hub.org">maia.hub.org</a> for no particular reason.<br />> <br />>It looked like moderation delay to me, especially since a whole bunch of<br />> stuff got approved at once.<br />> <br />> regards, tom lane<br />> <br />> -- <br />> Sent via pgsql-www mailing list (<a href="mailto:pgsql-www@postgresql.org">pgsql-www@postgresql.org</a>)<br/>> To make changes to your subscription:<br />><a href="http://www.postgresql.org/mailpref/pgsql-www">http://www.postgresql.org/mailpref/pgsql-www</a><br />
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Weren't we supposed to pass through unmoderated all emails coming from
> addresses subscribed to any of the lists?
No, that'd make it very easy for spammers, not to mention destroy the
main usefulness of the anti "unsubscribe" filters. My recollection is
that the way that that bit actually works is that if you're subscribed
to any of the lists, you're allowed to post to any other list as if you
were a subscriber; we did that mainly to avoid delaying cross-posted
mails.
Presumably all these mails got caught by one or another of the
moderation filter rules, but I didn't look to try to guess which,
except for Simon's commit message:
Log Message:
-----------
Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
Avoid hard-coding lockmode used for many altering DDL commands, allowing easier
future changes of lock levels. Implementation of initial analysis on DDL
sub-commands, so that many lock levels are now at ShareUpdateExclusiveLock or
^^^
I suppose this got trapped by the anti-subscribe-command filter.
Could we possibly narrow the command filters down so they're only
applied to very short messages, like one or two body lines? I've
had stuff delayed like this from those filters before, and it's
seriously annoying, particularly for commit messages.
regards, tom lane
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Alvaro Herrera
Дата:
Excerpts from Tom Lane's message of mié ago 04 12:00:54 -0400 2010: > Alvaro Herrera <alvherre@commandprompt.com> writes: > > Weren't we supposed to pass through unmoderated all emails coming from > > addresses subscribed to any of the lists? > > No, that'd make it very easy for spammers, not to mention destroy the > main usefulness of the anti "unsubscribe" filters. My recollection is > that the way that that bit actually works is that if you're subscribed > to any of the lists, you're allowed to post to any other list as if you > were a subscriber; we did that mainly to avoid delaying cross-posted > mails. Eh, that's precisely what I'm saying (or trying to). -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Alvaro Herrera
Дата:
Excerpts from Marc G. Fournier's message of mié ago 04 13:48:16 -0400 2010: > But even for posts that match that condition, there are other conditions > that also can apply (ie. header lengths, message lengths, admin commands, > duplicate posts, etc) ... Ah, yeah, in this case it's probably the "approve" at the start of the second line. -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Thom Brown
Дата:
On 4 August 2010 22:30, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Excerpts from Marc G. Fournier's message of mié ago 04 13:48:16 -0400 2010: > >> But even for posts that match that condition, there are other conditions >> that also can apply (ie. header lengths, message lengths, admin commands, >> duplicate posts, etc) ... > > Ah, yeah, in this case it's probably the "approve" at the start of the > second line. > > -- > Álvaro Herrera <alvherre@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > -- > Sent via pgsql-www mailing list (pgsql-www@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-www > We've just had a lot of emails from various groups arrive from up to 6 days ago now. One example for email entitled "NOTIFY action invoked when it shouldn't be" in -novice: Received: from postgresql.org (mail.postgresql.org [200.46.204.86])by mx2.hub.org (Postfix) with ESMTP id 02EB93F01C0B;Thu, 5 Aug 2010 12:41:01 -0300 (ADT) Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])by mail.postgresql.org (Postfix) with ESMTP id C0684632AAAfor<pgsql-novice-postgresql.org@mail.postgresql.org>; Fri, 30 Jul 2010 17:28:54 -0300 (ADT) -- Thom Brown Registered Linux user: #516935
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Marc G. Fournier"
Дата:
Yup, I just went through a bunch of the groups and approved stuff that 'slipped through the cracks' ... Then again, didn't realize we *had* no moderators for -novice ... feel like becoming one? On Thu, 5 Aug 2010, Thom Brown wrote: > On 4 August 2010 22:30, Alvaro Herrera <alvherre@commandprompt.com> wrote: >> Excerpts from Marc G. Fournier's message of mi? ago 04 13:48:16 -0400 2010: >> >>> But even for posts that match that condition, there are other conditions >>> that also can apply (ie. header lengths, message lengths, admin commands, >>> duplicate posts, etc) ... >> >> Ah, yeah, in this case it's probably the "approve" at the start of the >> second line. >> >> -- >> ?lvaro Herrera <alvherre@commandprompt.com> >> The PostgreSQL Company - Command Prompt, Inc. >> PostgreSQL Replication, Consulting, Custom Development, 24x7 support >> >> -- >> Sent via pgsql-www mailing list (pgsql-www@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-www >> > > We've just had a lot of emails from various groups arrive from up to 6 > days ago now. > > One example for email entitled "NOTIFY action invoked when it > shouldn't be" in -novice: > > Received: from postgresql.org (mail.postgresql.org [200.46.204.86]) > by mx2.hub.org (Postfix) with ESMTP id 02EB93F01C0B; > Thu, 5 Aug 2010 12:41:01 -0300 (ADT) > Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) > by mail.postgresql.org (Postfix) with ESMTP id C0684632AAA > for <pgsql-novice-postgresql.org@mail.postgresql.org>; Fri, 30 Jul > 2010 17:28:54 -0300 (ADT) > > -- > Thom Brown > Registered Linux user: #516935 > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
Thom Brown
Дата:
On 5 August 2010 17:00, Marc G. Fournier <scrappy@hub.org> wrote: > > Yup, I just went through a bunch of the groups and approved stuff that > 'slipped through the cracks' ... > > Then again, didn't realize we *had* no moderators for -novice ... feel like > becoming one? > Sure, okay. -- Thom Brown Registered Linux user: #516935
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Marc G. Fournier"
Дата:
email address to use? On Thu, 5 Aug 2010, Thom Brown wrote: > On 5 August 2010 17:00, Marc G. Fournier <scrappy@hub.org> wrote: >> >> Yup, I just went through a bunch of the groups and approved stuff that >> 'slipped through the cracks' ... >> >> Then again, didn't realize we *had* no moderators for -novice ... feel like >> becoming one? >> > > Sure, okay. > > -- > Thom Brown > Registered Linux user: #516935 > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org
Re: Mail delays (was: Sending the beta4 release announcement, don't approve ...)
От
"Marc G. Fournier"
Дата:
On Wed, 4 Aug 2010, Alvaro Herrera wrote: > Excerpts from Tom Lane's message of mi? ago 04 12:00:54 -0400 2010: >> Alvaro Herrera <alvherre@commandprompt.com> writes: >>> Weren't we supposed to pass through unmoderated all emails coming from >>> addresses subscribed to any of the lists? >> >> No, that'd make it very easy for spammers, not to mention destroy the >> main usefulness of the anti "unsubscribe" filters. My recollection is >> that the way that that bit actually works is that if you're subscribed >> to any of the lists, you're allowed to post to any other list as if you >> were a subscriber; we did that mainly to avoid delaying cross-posted >> mails. > > Eh, that's precisely what I'm saying (or trying to). By default: configset DEFAULT restrict_post <<ENDAAB GLOBAL: ENDAAB which means that as long as user is registered, they can post ... registerd != subscribed. This setting does apply to pgsql-www as well ... configset pgsql-www restrict_post <<ENDAAB GLOBAL: ENDAAB But even for posts that match that condition, there are other conditions that also can apply (ie. header lengths, message lengths, admin commands, duplicate posts, etc) ... ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org