Thread: leftover mail lists

leftover mail lists

From
Alvaro Herrera
Date:
Hi,

I spent some hours this weekend reworking the archives.pg.org code.
It's now closer to pure PHP, template-based and driven off text files
that derive from the database contents.

This means that as soon as you create a list in the database, it should
show up in the various menus.  There are still some places that have
hardcoded stuff, like the monthly indexes.

What concerns me now, however, is that this round of fixes has made me
aware of certain lists that look leftovers:

WARNING: description not found for list bapug
WARNING: description not found for list norpug
WARNING: description not found for list pgsql-hackers-pitr
WARNING: description not found for list phillypug
WARNING: description not found for list vepug


I'm wondering what to do about those.  Should we delete them?  Add them
to the "inactive lists" group?

The four PUG lists have had almost no traffic at all, and have existed
for months.  Of course, one could argue that the fact that they are not
listed in the site means that the prospective subscribers do not know
they even exist ...

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


Re: leftover mail lists

From
"Selena Deckelmann"
Date:
On Sun, Aug 31, 2008 at 6:46 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

> This means that as soon as you create a list in the database, it should
> show up in the various menus.  There are still some places that have
> hardcoded stuff, like the monthly indexes.

Thank you, Alvaro! This is very helpful.

> What concerns me now, however, is that this round of fixes has made me
> aware of certain lists that look leftovers:
>
> WARNING: description not found for list bapug

bapug is:
Please create a mailing list for the Buenos Aires, Venezuela PUG
List: bapug@postgresql.org
Owner: Guido Barosio <gbarosio@gmail.com>

I think Guido still plans to do some work with this.   Guido?

> WARNING: description not found for list norpug

I don't know who would be the owner for this list.

> WARNING: description not found for list phillypug

Gavin or Greg were planning to do something about PhillyPUG. Gavin? Greg?

> WARNING: description not found for list vepug

Santiago may know something about vepug -- Santiago?

-selena

-- 
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily


Re: leftover mail lists

From
"Guido Barosio"
Date:
BAPUG, yes please. Been busy during these days but I hope to take care
of this in a week or so.

(thanks for pointing out, Selena)

gb.-

On Mon, Sep 1, 2008 at 10:16 AM, Selena Deckelmann
<selenamarie@gmail.com> wrote:
> On Sun, Aug 31, 2008 at 6:46 PM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
>
>> This means that as soon as you create a list in the database, it should
>> show up in the various menus.  There are still some places that have
>> hardcoded stuff, like the monthly indexes.
>
> Thank you, Alvaro! This is very helpful.
>
>> What concerns me now, however, is that this round of fixes has made me
>> aware of certain lists that look leftovers:
>>
>> WARNING: description not found for list bapug
>
> bapug is:
> Please create a mailing list for the Buenos Aires, Venezuela PUG
> List: bapug@postgresql.org
> Owner: Guido Barosio <gbarosio@gmail.com>
>
> I think Guido still plans to do some work with this.   Guido?
>
>> WARNING: description not found for list norpug
>
> I don't know who would be the owner for this list.
>
>> WARNING: description not found for list phillypug
>
> Gavin or Greg were planning to do something about PhillyPUG. Gavin? Greg?
>
>> WARNING: description not found for list vepug
>
> Santiago may know something about vepug -- Santiago?
>
> -selena
>
> --
> Selena Deckelmann
> PDXPUG - http://pugs.postgresql.org/pdx
> Me - http://www.chesnok.com/daily
>



-- 
Guido Barosio
-----------------------
http://www.globant.com
guido.barosio@globant.com


Re: leftover mail lists

From
Alvaro Herrera
Date:
Selena Deckelmann escribió:

> > What concerns me now, however, is that this round of fixes has made me
> > aware of certain lists that look leftovers:
> >
> > WARNING: description not found for list bapug
> 
> bapug is:
> Please create a mailing list for the Buenos Aires, Venezuela PUG
> List: bapug@postgresql.org
> Owner: Guido Barosio <gbarosio@gmail.com>

Okay, I created bapug pointing to Buenos Aires, Argentina.  In the
unlikely case that Buenos Aires has migrated to Venezuela lately, be
sure to let me know ;-)


> > WARNING: description not found for list vepug
> 
> Santiago may know something about vepug -- Santiago?

Should I create it with name "Venezuela"?

I just noticed that I caused a regression :-(  In the new page, the
lists are shown by name, for example see in
http://archives.postgresql.org/bwpug/2008-08/index.php (old version)
   * Atlanta   * Austin   * Baltimore/DC   * Los Angeles   * Ohio   * Oklahoma   * Portland   * Seattle   * San
Francisco  * Suncoast   * Sydney   * Toronto   * United Kingdom
 

whereas in http://archives.postgresql.org/atlpug/ (new version) we have 
   *  atlpug   * austinpug   * bapug   * bostonpug   * bwpug   * lapug   * ohiopug   * okpug   * pdxpug   * seapug   *
sfpug  * spug   * sydpug   * torontopug   * ukpug
 

The previous version was using the Description field (or a transcription
thereof), but for all other lists it can be a long text.

Should we add a "short description" column to the database?

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


Re: leftover mail lists

From
"Selena Deckelmann"
Date:
On Mon, Sep 1, 2008 at 11:10 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Selena Deckelmann escribió:
>
>> bapug is:
>> Please create a mailing list for the Buenos Aires, Venezuela PUG
>> List: bapug@postgresql.org
>> Owner: Guido Barosio <gbarosio@gmail.com>
>
> Okay, I created bapug pointing to Buenos Aires, Argentina.  In the
> unlikely case that Buenos Aires has migrated to Venezuela lately, be
> sure to let me know ;-)

*sigh* Lo siento. I copied and pasted.  I do sort of know where Buenos
Aires is.

>> > WARNING: description not found for list vepug
>>
>> Santiago may know something about vepug -- Santiago?
>
> Should I create it with name "Venezuela"?

Yes!

> I just noticed that I caused a regression :-(  In the new page, the
> lists are shown by name, for example see in
> http://archives.postgresql.org/bwpug/2008-08/index.php (old version)
>
>    * Atlanta
>    * Austin
>    * Baltimore/DC
>    * Los Angeles
>    * Ohio
>    * Oklahoma
>    * Portland
>    * Seattle
>    * San Francisco
>    * Suncoast
>    * Sydney
>    * Toronto
>    * United Kingdom
>
> whereas in http://archives.postgresql.org/atlpug/ (new version) we have
>
>    *  atlpug
>    * austinpug
>    * bapug
>    * bostonpug
>    * bwpug
>    * lapug
>    * ohiopug
>    * okpug
>    * pdxpug
>    * seapug
>    * sfpug
>    * spug
>    * sydpug
>    * torontopug
>    * ukpug
>
> The previous version was using the Description field (or a transcription
> thereof), but for all other lists it can be a long text.
>
> Should we add a "short description" column to the database?

Please.

-selena



--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily


categorizing mailing lists

From
Alvaro Herrera
Date:
Selena Deckelmann escribió:
> On Mon, Sep 1, 2008 at 11:10 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:

> > The previous version was using the Description field (or a transcription
> > thereof), but for all other lists it can be a long text.
> >
> > Should we add a "short description" column to the database?
> 
> Please.

Okay, so I had a look at this and this is my conclusion: pgus-general
and pgeu-general are in the wrong category.  I was just talking to
Stefan:

(10:27:05) alvherre@pg: so here's what I want to do
(10:27:10) alvherre@pg: I need a new column in the lists table
(10:27:13) alvherre@pg: which is a short description
(10:27:21) alvherre@pg: that text is what I would put in the left-side menu
(10:27:40) alvherre@pg: it is pretty obvious that in "user groups" I can just name the geographical region
(10:27:48) alvherre@pg: and in regional lists, I can name the language
(10:27:59) alvherre@pg: but I cannot do sh*t about pgus and pgeu :-(
(10:28:13) alvherre@pg: maybe we should create another category for those??

What do people think about creating a new category (list group) and
sticking pgus-general and pgeu-general on it?  What should that category
be named?

Also, I take it nobody objects to the "short description" thing.

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


Re: categorizing mailing lists

From
Joshua Drake
Date:
On Tue, 2 Sep 2008 10:34:21 -0400
Alvaro Herrera <alvherre@commandprompt.com> wrote:

> Selena Deckelmann escribió:
> > On Mon, Sep 1, 2008 at 11:10 AM, Alvaro Herrera
> > <alvherre@commandprompt.com> wrote:
>
> > > The previous version was using the Description field (or a
> > > transcription thereof), but for all other lists it can be a long
> > > text.
> > >
> > > Should we add a "short description" column to the database?
> >
> > Please.
>
> Okay, so I had a look at this and this is my conclusion: pgus-general
> and pgeu-general are in the wrong category.  I was just talking to
> Stefan:
>
> (10:27:05) alvherre@pg: so here's what I want to do
> (10:27:10) alvherre@pg: I need a new column in the lists table
> (10:27:13) alvherre@pg: which is a short description
> (10:27:21) alvherre@pg: that text is what I would put in the
> left-side menu (10:27:40) alvherre@pg: it is pretty obvious that in
> "user groups" I can just name the geographical region (10:27:48)
> alvherre@pg: and in regional lists, I can name the language
> (10:27:59) alvherre@pg: but I cannot do sh*t about pgus and
> pgeu :-( (10:28:13) alvherre@pg: maybe we should create another
> category for those??
>
> What do people think about creating a new category (list group) and
> sticking pgus-general and pgeu-general on it?  What should that
> category be named?

Well it depends on what the purpose of the new category is.
PostgreSQLFR for example, where would that go? It isn't technically a
user group but is also a non profit. ITPUG is a little easier as it is
a user group and a non profit.

Sincerely,

Joshua D. Drake


>
> Also, I take it nobody objects to the "short description" thing.
>


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




Re: categorizing mailing lists

From
Alvaro Herrera
Date:
Joshua Drake escribió:
> On Tue, 2 Sep 2008 10:34:21 -0400
> Alvaro Herrera <alvherre@commandprompt.com> wrote:
> 
> > Selena Deckelmann escribió:

> > What do people think about creating a new category (list group) and
> > sticking pgus-general and pgeu-general on it?  What should that
> > category be named?
> 
> Well it depends on what the purpose of the new category is.
> PostgreSQLFR for example, where would that go? It isn't technically a
> user group but is also a non profit. ITPUG is a little easier as it is
> a user group and a non profit.

The purpose of the new category is to be able to categorize the lists
better.  If you are suggesting it to be named "Non profit" I think
that's a nonstarter, because all the other lists are not-for-profit too.

What I want is the categories to keep some relationships with the
descriptions we're going to give the lists.  So for PUGs we would use a
geographical region name (so the okpug list would be described as
"Oklahoma", etc).  For "regional lists" we would use a language name (so
pgsql-de-allgemein should be described as "German" or maybe "Deutsch").

If you're proposing to move pgus-general and pgeu-general under "User
Groups", that's fine with me too.


PostgreSQLFR and ITPUG have nothing to do here, because they're not
hosted on our archives site.

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


Re: categorizing mailing lists

From
Guillaume Lelarge
Date:
Joshua Drake a écrit :
> [...]
> Well it depends on what the purpose of the new category is.
> PostgreSQLFR for example, where would that go? It isn't technically a
> user group but is also a non profit. ITPUG is a little easier as it is
> a user group and a non profit.
> 

Why would you think PostgreSQLFR is not a user group?


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com


Re: categorizing mailing lists

From
"Selena Deckelmann"
Date:
On Tue, Sep 2, 2008 at 9:42 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Joshua Drake escribió:

>> Well it depends on what the purpose of the new category is.
>> PostgreSQLFR for example, where would that go? It isn't technically a
>> user group but is also a non profit. ITPUG is a little easier as it is
>> a user group and a non profit.
>
> The purpose of the new category is to be able to categorize the lists
> better.  If you are suggesting it to be named "Non profit" I think
> that's a nonstarter, because all the other lists are not-for-profit too.
>
> What I want is the categories to keep some relationships with the
> descriptions we're going to give the lists.  So for PUGs we would use a
> geographical region name (so the okpug list would be described as
> "Oklahoma", etc).  For "regional lists" we would use a language name (so
> pgsql-de-allgemein should be described as "German" or maybe "Deutsch").

Maybe 'associations'?

> If you're proposing to move pgus-general and pgeu-general under "User
> Groups", that's fine with me too.

That's fine with me. I imagine that JD/Michael/Bruce will weigh in
with their opinions.

-selena


--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily


Re: categorizing mailing lists

From
Joshua Drake
Date:
On Tue, 2 Sep 2008 16:04:45 -0700
"Selena Deckelmann" <selenamarie@gmail.com> wrote:


> Maybe 'associations'?
> 
> > If you're proposing to move pgus-general and pgeu-general under
> > "User Groups", that's fine with me too.
> 
> That's fine with me. I imagine that JD/Michael/Bruce will weigh in
> with their opinions.

I am pretty indifferent as long as the categorization is logical.

Sincerely,

Joshua D. Drake


> 
> -selena
> 
> 


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




Re: categorizing mailing lists

From
Robert Treat
Date:
On Tuesday 02 September 2008 19:19:34 Joshua Drake wrote:
> On Tue, 2 Sep 2008 16:04:45 -0700
>
> "Selena Deckelmann" <selenamarie@gmail.com> wrote:
> > Maybe 'associations'?
> >
> > > If you're proposing to move pgus-general and pgeu-general under
> > > "User Groups", that's fine with me too.
> >
> > That's fine with me. I imagine that JD/Michael/Bruce will weigh in
> > with their opinions.
>
> I am pretty indifferent as long as the categorization is logical.
>

"other" 

:-)

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL