Обсуждение: Remove pgfoundry URLs from docbot

Hi,

as some of you may know, I run the PostgreSQL docbot on a number of IRC 
channels. Recently I got a request to remove all pgfoundry URLs, because 
most of them (I did not check all of them) are dead.


Here is the full list from the docbot database:


docbot=> SELECT distinct(url) FROM docbot_url WHERE url ILIKE '%pgfoundry%';
                                                           url 


-------------------------------------------------------------------------------------------------------------------------
http://pgfoundry.org/projects/pgtclng/http://skytools.projects.pgfoundry.org/skytools-3.0//
http://pgfoundry.org/projects/solarispackages/http://pgfoundry.org/projects/edb-debugger/
http://pgfoundry.org/docman/?group_id=1000047http://pgfoundry.org/projects/sysauth/
http://pgfoundry.org/projects/pgunittest/http://pgfoundry.org/projects/backports/
http://pgnumerics.projects.pgfoundry.org/http://pgfoundry.org/projects/pgfouine/
http://skytools.projects.pgfoundry.org/skytools-3.0http://pgfoundry.org/projects/pgmemcache/
http://pgfoundry.org/projects/ptophttp://www.pgfoundry.org http://pgfoundry.org/projects/oledb/
http://pgfoundry.org/projects/sql2pg/http://pgfoundry.org/projects/pgtcl http://pgfoundry.org/projects/zoso/
http://pgfoundry.org/projects/poststat/http://pgfoundry.org/projects/autodoc/ http://pgfoundry.org/projects/pllua/
http://pgfoundry.org/docman/?group_id=1000089http://pgfoundry.org/projects/emailadt/
http://pgfoundry.org/projects/temporalhttp://pgfoundry.org/projects/dbsamples/
http://pgfoundry.org/projects/pg-migratorhttp://pgfoundry.org/projects/slony1-ctl/
http://pgfoundry.org/projects/pgiomonitor/http://pgfoundry.org/projects/plparrot/
http://pgfoundry.org/projects/pgintcl/http://pgfoundry.org/projects/pgsnmpd/ http://pgfoundry.org/projects/newsysviews/
http://pgfoundry.org/projects/pggraph/http://pgfoundry.org/projects/mysqlcompat
 
http://pgfoundry.org/docman/view.php/1000048/98/PostgreSQL-RPM-Installation-PGDG.pdf
http://pgfoundry.org/projects/pgtclng http://pgfoundry.org/projects/plproxy/ http://pgfoundry.org/projects/uri/
http://pgfoundry.org/projects/pgpool/http://pgfoundry.org/projects/plr http://pgfoundry.org/projects/timespan/
http://pgfoundry.org/projects/hstore-new/http://pgfoundry.org/projects/libpqtypes
http://pgfoundry.org/projects/shatypes/http://pgfoundry.org/projects/sparsegraph/ http://pgfoundry.org/projects/prefix/
http://pgfoundry.org/frs/?group_id=1000199http://pgfoundry.org/projects/pljava/ http://pgfoundry.org/projects/dbi-link/
http://pgfoundry.org/projects/pgbuildfarm/http://pgfoundry.org/projects/pgspy/ http://pgfoundry.org/projects/wikipedia/
http://pgfoundry.org/projects/configurator/http://pgfoundry.org/projects/postbio/
http://pgfoundry.org/projects/mysqlcompat/http://pgfoundry.org/projects/osxpgpkg/ http://pgfoundry.org/projects/docbot/
http://pgfoundry.org/projects/pgnixinstallerhttp://pgfoundry.org/projects/pgcluster/
http://pgfoundry.org/projects/fulldisjunction/http://pgfoundry.org/projects/plscheme/
http://pgfoundry.org/projects/pgsqlrpms/http://pgfoundry.org/projects/ignite/
http://pgfoundry.org/projects/biopostgres/http://pgfoundry.org/projects/tablelog/
http://pgfoundry.org/projects/enumkit/http://pgfoundry.org/projects/livecd/ http://pgfoundry.org/projects/reflectr/
http://pgfoundry.org/docman/?group_id=1000078http://pgfoundry.org/projects/plpsm/
http://pgfoundry.org/projects/mysql2pgsql/http://pgfoundry.org/projects/pllolcode/
http://pgfoundry.org/projects/dblink-tds/http://pgfoundry.org/projects/mssqlsupport/
http://pgfoundry.org/projects/autograph/http://pgfoundry.org/forum/forum.php?forum_id=344
http://pgfoundry.org/projects/pgtune/http://tpc.org/tpcw/ 
 
http://tpc.org/miscellaneous/TPC_W.folder/TPCWFAQ0802.htm 
http://pgfoundry.org/projects/tpc-w-php/ http://pgfoundry.org/projects/qbe/ http://pgfoundry.org/projects/pgbulkload/
http://pgfoundry.org/projects/pgfiledump/http://pgfoundry.org/projects/pginstaller/
http://pgfoundry.org/projects/oracle-fdw/http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/pagila/pagila/
http://www.pgfoundry.org/projects/pgclusterhttp://pgfoundry.org/projects/emaj/ http://pgfoundry.org/projects/pgjob/
http://pgfoundry.org/projects/npgsqlhttp://pgfoundry.org/projects/skytools/ http://pgfoundry.org/projects/pg-migrator/
http://pgfoundry.org/projects/python/http://pgfoundry.org/projects/ip4r/
 
(92 rows)


I'm inclined to follow this request, except if someone point out a valid 
reason not to do this. Or if someone has a better idea.


Thanks,

--             Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project

Hi,

On 05/13/2015 10:14 PM, Devrim Gündüz wrote:
>
> I have new URLs for many of'em. I'll send you soon.

Please send me this list. Want to update the docbot database and close
the ticket.


Thanks,

--             Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project

On Wed, May 13, 2015 at 09:14:18PM +0100, Devrim GUNDUZ wrote:
> Hi,
> 
> I have new URLs for many of'em. I'll send you soon.

So you're doing a Devrim-Andreas JOIN here?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

On 13.05.2015 12:30, Andreas 'ads' Scherbaum wrote:
>
> as some of you may know, I run the PostgreSQL docbot on a number of IRC
> channels. Recently I got a request to remove all pgfoundry URLs, because
> most of them (I did not check all of them) are dead.
>
>
> Here is the full list from the docbot database:
>
>
> docbot=> SELECT distinct(url) FROM docbot_url WHERE url ILIKE
> '%pgfoundry%';

Updated:

http://pgfoundry.org/projects/pgtclng/
-> http://sourceforge.net/projects/pgtclng/

http://pgfoundry.org/projects/edb-debugger/
-> http://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary

http://pgfoundry.org/projects/pgmemcache/
-> https://github.com/Ohmu/pgmemcache

http://pgfoundry.org/projects/dbi-link/
-> https://github.com/davidfetter/DBI-Link

http://pgfoundry.org/projects/docbot/
-> http://git.postgresql.org/gitweb/?p=docbot.git;a=shortlog;h=refs/heads/v2
(updated keywords: 'bot', 'pg_docbot', 'docbot' - for historical 
reasons, 'rtfm_please' points to the old url)

http://pgfoundry.org/projects/pgbuildfarm/
-> http://www.pgbuildfarm.org/

http://pgfoundry.org/projects/pgbulkload/
http://pgbulkload.projects.postgresql.org/
-> https://github.com/ossc-db/pg_bulkload

http://pgfoundry.org/projects/pgintcl/
-> http://sourceforge.net/projects/pgintcl/

http://pgfoundry.org/projects/pgtcl
-> http://flightaware.github.io/Pgtcl/

http://pgfoundry.org/projects/pljava/
-> https://github.com/tada/pljava

http://pgfoundry.org/projects/python/
-> https://github.com/python-postgres



Removed:

http://pgfoundry.org/docman/view.php/1000048/98/PostgreSQL-RPM-Installation-PGDG.pdf



The updates were made based on the pgfoundry site of each project. If 
there was a new link specified, this one was used for the update. In 
return: many of the old projects on pgfoundry have more recent websites, 
but this requires manual investigation.


--             Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project