Unix Technical Forum

UNSUBSCRIBE

This is a discussion on UNSUBSCRIBE within the Pgsql Performance forums, part of the PostgreSQL category; --> UNSUBSCRIBE ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 08:46 AM
Shoaib Burq
 
Posts: n/a
Default UNSUBSCRIBE

UNSUBSCRIBE

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 08:46 AM
Chris
 
Posts: n/a
Default Re: UNSUBSCRIBE

Shoaib Burq wrote:
> UNSUBSCRIBE


To unsubscribe:

List-Unsubscribe:
<mailto:majordomo@postgresql.org?body=unsub%20pgsq l-performance>


Email admins - Could we add this above or below the random tips that get
appended to every email ?

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-19-2008, 08:46 AM
Tom Lane
 
Posts: n/a
Default Re: UNSUBSCRIBE

Chris <dmagick@gmail.com> writes:
> Email admins - Could we add this above or below the random tips that get
> appended to every email ?


You mean like these headers that already get added to every list
message (these copied-and-pasted from your own message):

List-help: <mailto:majordomo@postgresql.org?body=help>
List-owner: <mailtogsql-performance-owner@postgresql.org>
List-subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsq l-performance>
List-unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsq l-performance>

Plus there are at least two of the "random tips" that deal with how to
unsubscribe. My feeling is that the people who can't figure this out
still won't figure it out, no matter how thick the cluebat we swing at
them :-(

Maybe the real problem is at the other end of the process, ie we should
require some evidence of a greater-than-room-temp IQ to subscribe in the
first place?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-19-2008, 08:46 AM
Chris
 
Posts: n/a
Default Re: UNSUBSCRIBE

Tom Lane wrote:
> Chris <dmagick@gmail.com> writes:
>
>>Email admins - Could we add this above or below the random tips that get
>>appended to every email ?

>
>
> You mean like these headers that already get added to every list
> message (these copied-and-pasted from your own message):


The headers aren't the first place you'd go looking for such info.. once
you know they are there it's ok.

> Maybe the real problem is at the other end of the process, ie we should
> require some evidence of a greater-than-room-temp IQ to subscribe in the
> first place?


Maybe The php-general list has

To unsubscribe, visit: http://www.php.net/unsub.php

at the bottom of every email, and there are still random unsubscribe
requests..

Ah well

--
Postgresql & php tutorials
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-19-2008, 08:46 AM
Tom Lane
 
Posts: n/a
Default Re: UNSUBSCRIBE

Chris <dmagick@gmail.com> writes:
> Tom Lane wrote:
>> Maybe the real problem is at the other end of the process, ie we should
>> require some evidence of a greater-than-room-temp IQ to subscribe in the
>> first place?


> Maybe The php-general list has


> To unsubscribe, visit: http://www.php.net/unsub.php


> at the bottom of every email, and there are still random unsubscribe
> requests..


That's depressing, indeed :-(

I'm not against spending a little bandwidth to provide unsub
instructions, but somehow I can't see putting an 8x10 color glossy
photograph with circles and arrows and a paragraph on the back [1]
of every list message to do it.

regards, tom lane

[1] http://www.guntheranderson.com/v/data/alicesre.htm

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-19-2008, 08:46 AM
Michael Glaesemann
 
Posts: n/a
Default Re: UNSUBSCRIBE


On May 10, 2006, at 14:42 , Tom Lane wrote:

> Chris <dmagick@gmail.com> writes:
>
>> Maybe The php-general list has

>
>> To unsubscribe, visit: http://www.php.net/unsub.php

>
>> at the bottom of every email, and there are still random unsubscribe
>> requests..


That will *always* happen. Just human nature and the numbers of
subscribers. However, a one-liner that either points to the webpage
for unsubscribing (probably easiest) or a brief description on how to
unsubscribe (To unsubscribe, send an email to
majordomo@postgresql.org with body "unsub pgsql-performance" (without
quotes)) may intercept a few more. Is there a way to configure
Majordomo to make even easier to unsubscribe? Just sending to pgsql-
performance-unsubscribe@postgresql.org or some such? I've seen other
mailing lists that do this. Requiring a specific command (what's the
command? in the subject or the body?) is one more place a person can
make a mistake. (I've recently switched mail accounts and unsubbed/
subbed from the lists I'm on. This latter style does make it a lot
easier.)

(And are there mail readers out there that can pick those subscribe/
unsubscribe headers from the list emails? Now *that'd* be sweet.)

Michael Glaesemann
grzm seespotcode net




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-19-2008, 08:47 AM
Tom Lane
 
Posts: n/a
Default Re: UNSUBSCRIBE

Michael Glaesemann <grzm@seespotcode.net> writes:
> (And are there mail readers out there that can pick those subscribe/
> unsubscribe headers from the list emails? Now *that'd* be sweet.)


Well, in my fairly ancient copy of exmh, any message with such headers
causes an additional menu to appear:

List...
help
unsubscribe
owner
subscribe
archive
id
post

Clicking on any of these takes you to the webpage referenced by the header.
(It looks like it's just generating menu entries for whatever "List-foo"
headers it finds; the behavior isn't real helpful for headers that don't
contain URLs, but most of these do.)

Whether there's anything mass-market that knows about these headers,
I dunno, but it's not like the spec hasn't been out there plenty long
enough:
ftp://ftp.rfc-editor.org/in-notes/rfc2369.txt

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-19-2008, 08:47 AM
Bruno Wolff III
 
Posts: n/a
Default Re: UNSUBSCRIBE

On Wed, May 10, 2006 at 01:15:11 -0400,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Maybe the real problem is at the other end of the process, ie we should
> require some evidence of a greater-than-room-temp IQ to subscribe in the
> first place?


I suspect it is more lazyiness that smarts. That had to at least figure out
how to respond to the confirm message in the first place in order to get
subscribed.
My theory is that they don't want to take the trouble to figure out how to
unsubscribe when they (think that they) can just send a message to the list
(not even the admin) asking to be unsubscribed and it will (well actually won't
on these lists) happen.

Maybe posts with "unsubscribe" in the subject could be held for moderation
and/or get an automated reply with instructions for unsubscribing.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-19-2008, 08:47 AM
Jim C. Nasby
 
Posts: n/a
Default Re: UNSUBSCRIBE

On Wed, May 10, 2006 at 11:10:37AM -0400, Tom Lane wrote:
> Michael Glaesemann <grzm@seespotcode.net> writes:
> > (And are there mail readers out there that can pick those subscribe/
> > unsubscribe headers from the list emails? Now *that'd* be sweet.)

>
> Well, in my fairly ancient copy of exmh, any message with such headers
> causes an additional menu to appear:


Based on the constantly broken threading in the lists, I'd bet that less
than 20% of posters use something more sophisticated than MS LookOut!,
and I'm sure that the stats for subscribers are far worse.

Does majordomo have an option to automagically handle such posts that
are sent to the post address instead of the admin address? I know
mailman can do that...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 04-19-2008, 08:47 AM
Jim C. Nasby
 
Posts: n/a
Default Re: UNSUBSCRIBE

On Wed, May 10, 2006 at 01:10:51PM -0500, Bruno Wolff III wrote:
> On Wed, May 10, 2006 at 01:15:11 -0400,
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >
> > Maybe the real problem is at the other end of the process, ie we should
> > require some evidence of a greater-than-room-temp IQ to subscribe in the
> > first place?

>
> I suspect it is more lazyiness that smarts. That had to at least figure out
> how to respond to the confirm message in the first place in order to get
> subscribed.
> My theory is that they don't want to take the trouble to figure out how to
> unsubscribe when they (think that they) can just send a message to the list
> (not even the admin) asking to be unsubscribed and it will (well actually won't
> on these lists) happen.


The confirm email has a directly-clickable link, or you can just reply
to it. From that standpoint, it's substantially easier and simpler than
unsubscribing is...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:29 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com