Re: [HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-11 Thread Magnus Hagander
On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
 Magnus Hagander escribió:
 On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
 alvhe...@2ndquadrant.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/


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-11 Thread Alvaro Herrera
Magnus Hagander escribió:
 On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
 alvhe...@2ndquadrant.com wrote:
  Magnus Hagander escribió:
  On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
  alvhe...@2ndquadrant.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 Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training  Services


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-11 Thread Magnus Hagander
On Mon, Feb 11, 2013 at 2:44 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
 Magnus Hagander escribió:
 On Mon, Feb 11, 2013 at 5:01 AM, Alvaro Herrera
 alvhe...@2ndquadrant.com wrote:
  Magnus Hagander escribió:
  On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
  alvhe...@2ndquadrant.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/


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-11 Thread Tom Lane
Magnus Hagander mag...@hagander.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


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-10 Thread Magnus Hagander
On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
 Magnus Hagander escribió:
 On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
 peter.geoghega...@gmail.com wrote:
  On 9 February 2013 15:24, Magnus Hagander mag...@hagander.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/


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-10 Thread Gurjeet Singh
On Sat, Feb 9, 2013 at 5:09 PM, Euler Taveira eu...@timbira.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/


Re: [HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-10 Thread Alvaro Herrera
Magnus Hagander escribió:
 On Sun, Feb 10, 2013 at 3:25 AM, Alvaro Herrera
 alvhe...@2ndquadrant.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 Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training  Services


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


[HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Gurjeet Singh
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-ow...@postgresql.org
Date: Sat, Feb 9, 2013 at 10:13 AM
Subject: Successful post to pgsql-hackers
To: Gurjeet Singh gurj...@singh.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/


Re: [HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Magnus Hagander
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 gurj...@singh.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-ow...@postgresql.org
 Date: Sat, Feb 9, 2013 at 10:13 AM
 Subject: Successful post to pgsql-hackers
 To: Gurjeet Singh gurj...@singh.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/


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Peter Geoghegan
On 9 February 2013 15:24, Magnus Hagander mag...@hagander.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


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Magnus Hagander
On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
peter.geoghega...@gmail.com wrote:
 On 9 February 2013 15:24, Magnus Hagander mag...@hagander.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/


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Gurjeet Singh
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 mag...@hagander.netwrote:

 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 gurj...@singh.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-ow...@postgresql.org
  Date: Sat, Feb 9, 2013 at 10:13 AM
  Subject: Successful post to pgsql-hackers
  To: Gurjeet Singh gurj...@singh.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/


Re: [HACKERS] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Euler Taveira
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


-- 
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] Fwd: Successful post to pgsql-hackers

2013-02-09 Thread Alvaro Herrera
Magnus Hagander escribió:
 On Sat, Feb 9, 2013 at 4:31 PM, Peter Geoghegan
 peter.geoghega...@gmail.com wrote:
  On 9 February 2013 15:24, Magnus Hagander mag...@hagander.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 Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training  Services


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