Mailing list archiver

Started by Jordan Deitchover 8 years ago13 messagesgeneral
Jump to latest
#1Jordan Deitch
jwdeitch@gmail.com

This project serves to organize and archive the postgres mailing list:

http://pg.rsa.pub/

Let me know what you think, or if you have any suggestions.
I left email addresses off the site to protect privacy.

p.s: you can click messages to collapse the tree

Thanks

#2Kellner Thiemo
thiemo.kellner@usb.ch
In reply to: Jordan Deitch (#1)
RE: Mailing list archiver

Looks nice, thanks, however, I could not find select posts to this list from 20th December and 19th Dezember respectively.

Kind regards Thiemo

#3Michelle Konzack
linux4michelle@tamay-dogan.net
In reply to: Jordan Deitch (#1)
Re: Mailing list archiver

Hello Jordan,

what software is the server running?
Is it Open Source?

I am interested in it because I run a small site for my BioFarm
in Estonia and use the Courier Mailing List Manager.

Thanks in avance
Michelle

Am 2018-01-03 hackte Jordan Deitch in die Tasten:

This project serves to organize and archive the postgres mailing list:

http://pg.rsa.pub/

Let me know what you think, or if you have any suggestions.
I left email addresses off the site to protect privacy.

p.s: you can click messages to collapse the tree

Thanks

------------------------------------------------------------------------

--
Michelle Konzack
00372-54541400

#4Magnus Hagander
magnus@hagander.net
In reply to: Michelle Konzack (#3)
Re: Mailing list archiver

On Wed, Jan 3, 2018 at 11:19 AM, Michelle Konzack <
linux4michelle@tamay-dogan.net> wrote:

Hello Jordan,

what software is the server running?
Is it Open Source?

I am interested in it because I run a small site for my BioFarm
in Estonia and use the Courier Mailing List Manager.

Just as a pointer, if you want to take a look at the code the main
postgresql archives uses, you can find it at
https://git.postgresql.org/gitweb/?p=pgarchives.git. Since it's postgres
it's of course open source, and contributions are welcome!

I can't tell you how it differs from the one Jordan is posting, because if
I go to that site I just get empty templates and it's failing to load the
javascript properly from here. But I'm sure you've seen the archives, and
can compare yourself! I'm sure it has good points to it, otherwise it
wouldn't have been written :)

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;

#5Peter J. Holzer
hjp-pgsql@hjp.at
In reply to: Magnus Hagander (#4)
Re: Mailing list archiver

On 2018-01-03 11:28:06 +0100, Magnus Hagander wrote:

I can't tell you how it differs from the one Jordan is posting, because if I go
to that site I just get empty templates and it's failing to load the javascript
properly from here.

I'm surprised that you even get an empty template.

pg.rsa.pub has a CNAME of
http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com. which is a syntax
error (the value of a CNAME record must be a domain name, not an URL).
Here at least the Linux resolver library gives up and reports that the
host name doesn't exist.

A less picky resolver might accept
http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com as a valid host
name (although ":" and "/" aren't allowed in host names) and find that
there is actually another CNAME record which points to
s3-website-us-east-1.amazonaws.com which has an A record. So that might
work on some platforms.

hp

--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp@hjp.at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/&gt;

#6Michelle Konzack
linux4michelle@tamay-dogan.net
In reply to: Peter J. Holzer (#5)
Re: Mailing list archiver

This is bizzar, because the URL <http://pg.rsa.pub/&gt;
is perfectly working for me.

Am DATE hackte AUTHOR in die Tasten: Peter J. Holzer

On 2018-01-03 11:28:06 +0100, Magnus Hagander wrote:

I can't tell you how it differs from the one Jordan is posting, because
if I go
to that site I just get empty templates and it's failing to load the
javascript
properly from here.

I'm surprised that you even get an empty template.

pg.rsa.pub has a CNAME of
http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com. which is a syntax
error (the value of a CNAME record must be a domain name, not an URL).
Here at least the Linux resolver library gives up and reports that the
host name doesn't exist.

A less picky resolver might accept
http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com as a valid host
name (although ":" and "/" aren't allowed in host names) and find that
there is actually another CNAME record which points to
s3-website-us-east-1.amazonaws.com which has an A record. So that might
work on some platforms.

hp

------------------------------------------------------------------------

--
Michelle Konzack
00372-54541400

#7Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Michelle Konzack (#6)
Re: Mailing list archiver

Michelle Konzack wrote:

This is bizzar, because the URL <http://pg.rsa.pub/&gt;
is perfectly working for me.

It fails for me exactly as Peter described.

I added this entry to /etc/hosts:

54.231.120.105 pg.rsa.pub

and then I could see the site. It looks like an interesting interface.
There are bugs related to loading pages, and the collapsing feature is a
bit odd, but it seems promising.

--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

#8Jordan Deitch
jwdeitch@gmail.com
In reply to: Alvaro Herrera (#7)
Re: Mailing list archiver

Thanks for the feedback! I will continue to address these issues, and I
intend on adding #postgresql IRC logs as well :-)
This software was written by me particularly for this purpose; I will clean
up / comment, then publish the source to my github - I'll shoot a reply
here with that sometime in the next day or two

On Wed, Jan 3, 2018 at 8:50 AM, Alvaro Herrera <alvherre@alvh.no-ip.org>
wrote:

Show quoted text

Michelle Konzack wrote:

This is bizzar, because the URL <http://pg.rsa.pub/&gt;
is perfectly working for me.

It fails for me exactly as Peter described.

I added this entry to /etc/hosts:

54.231.120.105 pg.rsa.pub

and then I could see the site. It looks like an interesting interface.
There are bugs related to loading pages, and the collapsing feature is a
bit odd, but it seems promising.

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

#9Michelle Konzack
linux4michelle@tamay-dogan.net
In reply to: Jordan Deitch (#8)
Re: Mailing list archiver

Hi Jordan,

I was on the GIT server, but is there a possibility,
to get the whole thing as tar ball?

I am currently under this horribel Windows 7 because the screen
of my Compaq Laptop broke (simply black) and I am unable to get
things from the GIT server except file by file.

This, why I have to use the old squirrelmail instead of mutt...

Ahja, I do not use Majordomo, which mean, I have to change things
in the files but I like to know, how you get the incoming messages
into the database?

I generally filter the messages trough procmail and feed it to the
appropriated program to process them.

Thanks
Michelle

Am DATE hackte AUTHOR in die Tasten: Jordan Deitch

Thanks for the feedback! I will continue to address these issues, and I
intend on adding #postgresql IRC logs as well :-)
This software was written by me particularly for this purpose; I will
clean
up / comment, then publish the source to my github - I'll shoot a reply
here with that sometime in the next day or two

On Wed, Jan 3, 2018 at 8:50 AM, Alvaro Herrera <alvherre@alvh.no-ip.org>
wrote:

Michelle Konzack wrote:

This is bizzar, because the URL <http://pg.rsa.pub/&gt;
is perfectly working for me.

It fails for me exactly as Peter described.

I added this entry to /etc/hosts:

54.231.120.105 pg.rsa.pub

and then I could see the site. It looks like an interesting interface.
There are bugs related to loading pages, and the collapsing feature is a
bit odd, but it seems promising.

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

--
Michelle Konzack
00372-54541400

#10Steve Atkins
steve@blighty.com
In reply to: Jordan Deitch (#8)
Re: Mailing list archiver

On Jan 3, 2018, at 6:00 AM, Jordan Deitch <jwdeitch@gmail.com> wrote:

Thanks for the feedback! I will continue to address these issues, and I intend on adding #postgresql IRC logs as well :-)

Please don't make a public archive of #postgresql without discussion. I believe the general feeling of those who use the channel is that a public archive of it is not wanted.

Cheers,
Steve

#11Ivan E. Panchenko
i.panchenko@postgrespro.ru
In reply to: Jordan Deitch (#1)
Re: Mailing list archiver

Hi,

Btw, there is also another web interface to the mail list archives at
Postgres Pro web site, https://postgrespro.com/list

Regards,

Ivan

 03.01.2018 05:45, Jordan Deitch пишет:

Show quoted text

This project serves to organize and archive the postgres mailing list:

http://pg.rsa.pub/

Let me know what you think, or if you have any suggestions.
I left email addresses off the site to protect privacy.

p.s: you can click messages to collapse the tree

Thanks

#12Magnus Hagander
magnus@hagander.net
In reply to: Steve Atkins (#10)
Re: Mailing list archiver

On Wed, Jan 3, 2018 at 6:53 PM, Steve Atkins <steve@blighty.com> wrote:

On Jan 3, 2018, at 6:00 AM, Jordan Deitch <jwdeitch@gmail.com> wrote:

Thanks for the feedback! I will continue to address these issues, and I

intend on adding #postgresql IRC logs as well :-)

Please don't make a public archive of #postgresql without discussion. I
believe the general feeling of those who use the channel is that a public
archive of it is not wanted.

Yeah, this has been discussed repeatedly in the past and the conclusion has
always been to not do that. There are a number of people who specifically
use the IRC channel to avoid posting to a public list, and they should be
allowed to do so without a public archive.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;

#13Jordan Deitch
jwdeitch@gmail.com
In reply to: Magnus Hagander (#12)
Re: Mailing list archiver

Understood, this makes sense. Thanks for this feedback

On Wed, Jan 3, 2018 at 4:36 PM, Magnus Hagander <magnus@hagander.net> wrote:

Show quoted text

On Wed, Jan 3, 2018 at 6:53 PM, Steve Atkins <steve@blighty.com> wrote:

On Jan 3, 2018, at 6:00 AM, Jordan Deitch <jwdeitch@gmail.com> wrote:

Thanks for the feedback! I will continue to address these issues, and I

intend on adding #postgresql IRC logs as well :-)

Please don't make a public archive of #postgresql without discussion. I
believe the general feeling of those who use the channel is that a public
archive of it is not wanted.

Yeah, this has been discussed repeatedly in the past and the conclusion
has always been to not do that. There are a number of people who
specifically use the IRC channel to avoid posting to a public list, and
they should be allowed to do so without a public archive.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;