Fwd: Successful post to pgsql-hackers

Lists: pgsql-hackers
From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 15:17:34
Message-ID: CABwTF4WBJUXEaqLcE0SRgWpRW=5bVLMKNnLTYDBGE1tSjX3cRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Recently I have started getting these confirmations for every email I send
to the mailing lists. I think it's related to the fact that I recently
switched to using a new email address.

How can I turn these notifications off?

---------- Forwarded message ----------
From: <pgsql-hackers-owner(at)postgresql(dot)org>
Date: Sat, Feb 9, 2013 at 10:13 AM
Subject: Successful post to pgsql-hackers
To: Gurjeet Singh <gurjeet(at)singh(dot)im>

Your message to the pgsql-hackers list, posted on
Sat, 9 Feb 2013 10:11:05 -0500

with subject
Re: pg_prewarm

is currently being delivered.

--
Gurjeet Singh

http://gurjeet.singh.im/


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Gurjeet Singh <gurjeet(at)singh(dot)im>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 15:24:37
Message-ID: CABUevEwuXvefJk7=LB=od1y_MoKSvzNLjTSP-2y53KhYwk61Eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

It's in your personal majordomo settings. I don't think it's related
to that at all, but it's a flag you set on your subscription, so
perhaps you set it by mistake.

You shold be able to set it from https://mail.postgresql.org. The
setting you're looking for is "ackpost", and you'll want to turn it
off.

//Magnus

On Sat, Feb 9, 2013 at 4:17 PM, Gurjeet Singh <gurjeet(at)singh(dot)im> wrote:
> Recently I have started getting these confirmations for every email I send
> to the mailing lists. I think it's related to the fact that I recently
> switched to using a new email address.
>
> How can I turn these notifications off?
>
> ---------- Forwarded message ----------
> From: <pgsql-hackers-owner(at)postgresql(dot)org>
> Date: Sat, Feb 9, 2013 at 10:13 AM
> Subject: Successful post to pgsql-hackers
> To: Gurjeet Singh <gurjeet(at)singh(dot)im>
>
>
> Your message to the pgsql-hackers list, posted on
> Sat, 9 Feb 2013 10:11:05 -0500
>
> with subject
> Re: pg_prewarm
>
> is currently being delivered.
>
>
>
> --
> Gurjeet Singh
>
> http://gurjeet.singh.im/

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


From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 15:31:22
Message-ID: CAEYLb_Xdh=UDs=5aDvr2PYzn-TSi=BHcQD3t5xU43F_CvtW2Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 9 February 2013 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> It's in your personal majordomo settings. I don't think it's related
> to that at all, but it's a flag you set on your subscription, so
> perhaps you set it by mistake.

Then I must have set it by mistake too, when I recently changed e-mail
addresses.

--
Regards,
Peter Geoghegan


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 15:36:15
Message-ID: CABUevEyHa=kPg2WdWYMUdL+D-NtFv4MAiqM7zO=kO-ZtU-1y1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
<peter(dot)geoghegan86(at)gmail(dot)com> wrote:
> On 9 February 2013 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> It's in your personal majordomo settings. I don't think it's related
>> to that at all, but it's a flag you set on your subscription, so
>> perhaps you set it by mistake.
>
> Then I must have set it by mistake too, when I recently changed e-mail
> addresses.

Hmm. I wonder if Alvaro may have accidentally switched the default, if
it happened to more than one person. Alvaro, can you check?

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


From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 15:45:08
Message-ID: CABwTF4VkzuFWuKoDjtvdj+uTcgSLXETBtpNDC86md0mjLkOuHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I tried the lists page and disabled the 'selfcopy' since the 'ackpot' was
kinda hidden under the mailing list names. I have updated the settings
again to disable ackpost, and enable the selfcopy. This email will be test
if that worked.

BTW, I hope I understand what selfcopy is: send a copy to yourself. Why
would that be turned on by default?

On Sat, Feb 9, 2013 at 10:24 AM, Magnus Hagander <magnus(at)hagander(dot)net>wrote:

> It's in your personal majordomo settings. I don't think it's related
> to that at all, but it's a flag you set on your subscription, so
> perhaps you set it by mistake.
>
> You shold be able to set it from https://mail.postgresql.org. The
> setting you're looking for is "ackpost", and you'll want to turn it
> off.
>
> //Magnus
>
>
> On Sat, Feb 9, 2013 at 4:17 PM, Gurjeet Singh <gurjeet(at)singh(dot)im> wrote:
> > Recently I have started getting these confirmations for every email I
> send
> > to the mailing lists. I think it's related to the fact that I recently
> > switched to using a new email address.
> >
> > How can I turn these notifications off?
> >
> > ---------- Forwarded message ----------
> > From: <pgsql-hackers-owner(at)postgresql(dot)org>
> > Date: Sat, Feb 9, 2013 at 10:13 AM
> > Subject: Successful post to pgsql-hackers
> > To: Gurjeet Singh <gurjeet(at)singh(dot)im>
> >
> >
> > Your message to the pgsql-hackers list, posted on
> > Sat, 9 Feb 2013 10:11:05 -0500
> >
> > with subject
> > Re: pg_prewarm
> >
> > is currently being delivered.
> >
> >
> >
> > --
> > Gurjeet Singh
> >
> > http://gurjeet.singh.im/
>
>
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
>

--
Gurjeet Singh

http://gurjeet.singh.im/


From: Euler Taveira <euler(at)timbira(dot)com>
To: Gurjeet Singh <gurjeet(at)singh(dot)im>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-09 22:09:23
Message-ID: 5116C913.4030207@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 09-02-2013 13:45, Gurjeet Singh wrote:
> BTW, I hope I understand what selfcopy is: send a copy to yourself. Why would
> that be turned on by default?
>
If you want to reply to yourself...

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento


From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-10 02:25:29
Message-ID: 20130210022528.GA9112@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus Hagander escribió:
> On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
> <peter(dot)geoghegan86(at)gmail(dot)com> wrote:
> > On 9 February 2013 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> >> It's in your personal majordomo settings. I don't think it's related
> >> to that at all, but it's a flag you set on your subscription, so
> >> perhaps you set it by mistake.
> >
> > Then I must have set it by mistake too, when I recently changed e-mail
> > addresses.
>
> Hmm. I wonder if Alvaro may have accidentally switched the default, if
> it happened to more than one person. Alvaro, can you check?

I hadn't touched this, but Andres Freund had already complained about
this before. I just checked and yes, it seems that the flag to send a
confirmation for each post is set. I have reset it.

I also took the opportunity to set the flags to send confirmation emails
when a posting is rejected or stalled for moderation. We discussed this
previously (Pavel Stehule complained about it).

I changed the defaults for new subscribers, and also the flags values
for all existing subscribers, note.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-10 11:03:57
Message-ID: CABUevEwxtho3K=HFXjAnLHVpWYT+cgce2SAAZv1Bp_yy-tY29A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> Magnus Hagander escribió:
>> On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
>> <peter(dot)geoghegan86(at)gmail(dot)com> wrote:
>> > On 9 February 2013 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> >> It's in your personal majordomo settings. I don't think it's related
>> >> to that at all, but it's a flag you set on your subscription, so
>> >> perhaps you set it by mistake.
>> >
>> > Then I must have set it by mistake too, when I recently changed e-mail
>> > addresses.
>>
>> Hmm. I wonder if Alvaro may have accidentally switched the default, if
>> it happened to more than one person. Alvaro, can you check?
>
> I hadn't touched this, but Andres Freund had already complained about
> this before. I just checked and yes, it seems that the flag to send a
> confirmation for each post is set. I have reset it.
>
> I also took the opportunity to set the flags to send confirmation emails
> when a posting is rejected or stalled for moderation. We discussed this
> previously (Pavel Stehule complained about it).
>
> I changed the defaults for new subscribers, and also the flags values
> for all existing subscribers, note.

For *all* existing subscribers, or those that had not changed their
defaults? And did you change just those flags, or for all flags?

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


From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: Euler Taveira <euler(at)timbira(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 03:54:22
Message-ID: CABwTF4UpTODgzGUDhA6EDrxvexqCG4Q+P9cHbeen+PVHqf4Ptw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sat, Feb 9, 2013 at 5:09 PM, Euler Taveira <euler(at)timbira(dot)com> wrote:

> On 09-02-2013 13:45, Gurjeet Singh wrote:
> > BTW, I hope I understand what selfcopy is: send a copy to yourself. Why
> would
> > that be turned on by default?
> >
> If you want to reply to yourself...

Wouldn't I be using the copy in my "sent" folder to do that?

I guess it is a non-issue for me since my mail provider (GMail) does not
show me the mail I sent to myself as a duplicate; it at least seems that
way.

--
Gurjeet Singh

http://gurjeet.singh.im/


From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 04:01:35
Message-ID: 20130211040134.GA10444@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus Hagander escribió:
> On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
> <alvherre(at)2ndquadrant(dot)com> wrote:

> > I changed the defaults for new subscribers, and also the flags values
> > for all existing subscribers, note.
>
> For *all* existing subscribers, or those that had not changed their
> defaults? And did you change just those flags, or for all flags?

For all existing subscribers, I changed the ackpost (to off), ackreject
(to on), ackstall (to on) flags. Other flags were untouched. There's
no way to distinguish "unchanged" from "set to the same as the default"
in mj2, I'm afraid.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 11:22:40
Message-ID: CABUevEx1AiDSKwiogDqr0VdjsZsyHck5dAHsJMHcrjW3t00Mog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> Magnus Hagander escribió:
>> On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
>> <alvherre(at)2ndquadrant(dot)com> wrote:
>
>> > I changed the defaults for new subscribers, and also the flags values
>> > for all existing subscribers, note.
>>
>> For *all* existing subscribers, or those that had not changed their
>> defaults? And did you change just those flags, or for all flags?
>
> For all existing subscribers, I changed the ackpost (to off), ackreject
> (to on), ackstall (to on) flags. Other flags were untouched. There's
> no way to distinguish "unchanged" from "set to the same as the default"
> in mj2, I'm afraid.

Yeah, it seems you at least broke some cronjobs that relied on the old
default...

That said, I think that was pretty darn unfriendly to those who
potentially changed their own configuration. E.g. all those who
potentially set their ackpost to on intentionally years ago, have now
lost that one... But it's clearly too late to do anything about that
one now.

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


From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 13:44:41
Message-ID: 20130211134441.GA4737@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus Hagander escribió:
> On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
> <alvherre(at)2ndquadrant(dot)com> wrote:
> > Magnus Hagander escribió:
> >> On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
> >> <alvherre(at)2ndquadrant(dot)com> wrote:
> >
> >> > I changed the defaults for new subscribers, and also the flags values
> >> > for all existing subscribers, note.
> >>
> >> For *all* existing subscribers, or those that had not changed their
> >> defaults? And did you change just those flags, or for all flags?
> >
> > For all existing subscribers, I changed the ackpost (to off), ackreject
> > (to on), ackstall (to on) flags. Other flags were untouched. There's
> > no way to distinguish "unchanged" from "set to the same as the default"
> > in mj2, I'm afraid.
>
> Yeah, it seems you at least broke some cronjobs that relied on the old
> default...

Huh? We had cronjobs that relied on ackpost being set? Please elaborate.

> That said, I think that was pretty darn unfriendly to those who
> potentially changed their own configuration. E.g. all those who
> potentially set their ackpost to on intentionally years ago, have now
> lost that one... But it's clearly too late to do anything about that
> one now.

Yes, that true. Sorry about that. As I said, there was no way to
figure that out.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 13:53:03
Message-ID: CABUevEzHJtiLHJQORiAPZp7c0kOLSjD9ysyz2gMNbYgBipa6Lg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, Feb 11, 2013 at 2:44 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> Magnus Hagander escribió:
>> On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
>> <alvherre(at)2ndquadrant(dot)com> wrote:
>> > Magnus Hagander escribió:
>> >> On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
>> >> <alvherre(at)2ndquadrant(dot)com> wrote:
>> >
>> >> > I changed the defaults for new subscribers, and also the flags values
>> >> > for all existing subscribers, note.
>> >>
>> >> For *all* existing subscribers, or those that had not changed their
>> >> defaults? And did you change just those flags, or for all flags?
>> >
>> > For all existing subscribers, I changed the ackpost (to off), ackreject
>> > (to on), ackstall (to on) flags. Other flags were untouched. There's
>> > no way to distinguish "unchanged" from "set to the same as the default"
>> > in mj2, I'm afraid.
>>
>> Yeah, it seems you at least broke some cronjobs that relied on the old
>> default...
>
> Huh? We had cronjobs that relied on ackpost being set? Please elaborate.

Nah, cronjobs that synchronized the flags for certain subscribers.
Didn't you receive a copy of the error message? :) It didn't actually
beak it, but it's spewing warnings.

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


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Gurjeet Singh <gurjeet(at)singh(dot)im>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Successful post to pgsql-hackers
Date: 2013-02-11 15:15:15
Message-ID: 19822.1360595715@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> That said, I think that was pretty darn unfriendly to those who
> potentially changed their own configuration. E.g. all those who
> potentially set their ackpost to on intentionally years ago, have now
> lost that one... But it's clearly too late to do anything about that
> one now.

The new defaults are clearly saner. But maybe it's worth a post on
pgsql-announce to let people know this was done? If there is anybody
out there who's expecting ackpost, that would cue them to fix it.

regards, tom lane