Thread: 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,<br /><br /> I have new URLs for many of'em. I'll send you soon.<br /><br /> Cheers,<br /><br /><div
class="gmail_quote">OnMay 13, 2015 11:30:42 AM GMT+01:00, Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
wrote:<blockquoteclass="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;"><pre class="k9mail"><br />Hi,<br /><br />as some of you may know, I run the PostgreSQL docbot on a
numberof IRC <br />channels. Recently I got a request to remove all pgfoundry URLs, because <br />most of them (I did
notcheck all of them) are dead.<br /><br /><br />Here is the full list from the docbot database:<br /><br /><br
/>docbot=>SELECT distinct(url) FROM docbot_url WHERE url ILIKE '%pgfoundry%';<br /><br />
url <br /><br /><hr /><br /> <a
href="http://pgfoundry.org/projects/pgtclng">http://pgfoundry.org/projects/pgtclng</a>/<br/> <a
href="http://skytools.projects.pgfoundry.org/skytools-3.0">http://skytools.projects.pgfoundry.org/skytools-3.0</a>//<br
/> <a href="http://pgfoundry.org/projects/solarispackages">http://pgfoundry.org/projects/solarispackages</a>/<br /> <a
href="http://pgfoundry.org/projects/edb-debugger">http://pgfoundry.org/projects/edb-debugger</a>/<br/> <a
href="http://pgfoundry.org/docman/?group_id=1000047">http://pgfoundry.org/docman/?group_id=1000047</a><br/> <a
href="http://pgfoundry.org/projects/sysauth">http://pgfoundry.org/projects/sysauth</a>/<br/> <a
href="http://pgfoundry.org/projects/pgunittest">http://pgfoundry.org/projects/pgunittest</a>/<br/> <a
href="http://pgfoundry.org/projects/backports">http://pgfoundry.org/projects/backports</a>/<br/> <a
href="http://pgnumerics.projects.pgfoundry.org">http://pgnumerics.projects.pgfoundry.org</a>/<br/> <a
href="http://pgfoundry.org/projects/pgfouine">http://pgfoundry.org/projects/pgfouine</a>/<br/> <a
href="http://skytools.projects.pgfoundry.org/skytools-3.0">http://skytools.projects.pgfoundry.org/skytools-3.0</a><br/>
<a href="http://pgfoundry.org/projects/pgmemcache">http://pgfoundry.org/projects/pgmemcache</a>/<br /> <a
href="http://pgfoundry.org/projects/ptop">http://pgfoundry.org/projects/ptop</a><br/> <a
href="http://www.pgfoundry.org">http://www.pgfoundry.org</a><br/> <a
href="http://pgfoundry.org/projects/oledb">http://pgfoundry.org/projects/oledb</a>/<br/> <a
href="http://pgfoundry.org/projects/sql2pg">http://pgfoundry.org/projects/sql2pg</a>/<br/> <a
href="http://pgfoundry.org/projects/pgtcl">http://pgfoundry.org/projects/pgtcl</a><br/> <a
href="http://pgfoundry.org/projects/zoso">http://pgfoundry.org/projects/zoso</a>/<br/> <a
href="http://pgfoundry.org/projects/poststat">http://pgfoundry.org/projects/poststat</a>/<br/> <a
href="http://pgfoundry.org/projects/autodoc">http://pgfoundry.org/projects/autodoc</a>/<br/> <a
href="http://pgfoundry.org/projects/pllua">http://pgfoundry.org/projects/pllua</a>/<br/> <a
href="http://pgfoundry.org/docman/?group_id=1000089">http://pgfoundry.org/docman/?group_id=1000089</a><br/> <a
href="http://pgfoundry.org/projects/emailadt">http://pgfoundry.org/projects/emailadt</a>/<br/> <a
href="http://pgfoundry.org/projects/temporal">http://pgfoundry.org/projects/temporal</a><br/> <a
href="http://pgfoundry.org/projects/dbsamples">http://pgfoundry.org/projects/dbsamples</a>/<br/> <a
href="http://pgfoundry.org/projects/pg-migrator">http://pgfoundry.org/projects/pg-migrator</a><br/> <a
href="http://pgfoundry.org/projects/slony1-ctl">http://pgfoundry.org/projects/slony1-ctl</a>/<br/> <a
href="http://pgfoundry.org/projects/pgiomonitor">http://pgfoundry.org/projects/pgiomonitor</a>/<br/> <a
href="http://pgfoundry.org/projects/plparrot">http://pgfoundry.org/projects/plparrot</a>/<br/> <a
href="http://pgfoundry.org/projects/pgintcl">http://pgfoundry.org/projects/pgintcl</a>/<br/> <a
href="http://pgfoundry.org/projects/pgsnmpd">http://pgfoundry.org/projects/pgsnmpd</a>/<br/> <a
href="http://pgfoundry.org/projects/newsysviews">http://pgfoundry.org/projects/newsysviews</a>/<br/> <a
href="http://pgfoundry.org/projects/pggraph">http://pgfoundry.org/projects/pggraph</a>/<br/> <a
href="http://pgfoundry.org/projects/mysqlcompat">http://pgfoundry.org/projects/mysqlcompat</a><br/> <br /><a
href="http://pgfoundry.org/docman/view.php/1000048/98/PostgreSQL-RPM-Installation-PGDG.pdf">http://pgfoundry.org/docman/view.php/1000048/98/PostgreSQL-RPM-Installation-PGDG.pdf</a><br
/><ahref="http://pgfoundry.org/projects/pgtclng">http://pgfoundry.org/projects/pgtclng</a><br /> <a
href="http://pgfoundry.org/projects/plproxy">http://pgfoundry.org/projects/plproxy</a>/<br/> <a
href="http://pgfoundry.org/projects/uri">http://pgfoundry.org/projects/uri</a>/<br/> <a
href="http://pgfoundry.org/projects/pgpool">http://pgfoundry.org/projects/pgpool</a>/<br/> <a
href="http://pgfoundry.org/projects/plr">http://pgfoundry.org/projects/plr</a><br/> <a
href="http://pgfoundry.org/projects/timespan">http://pgfoundry.org/projects/timespan</a>/<br/> <a
href="http://pgfoundry.org/projects/hstore-new">http://pgfoundry.org/projects/hstore-new</a>/<br/> <a
href="http://pgfoundry.org/projects/libpqtypes">http://pgfoundry.org/projects/libpqtypes</a><br/> <a
href="http://pgfoundry.org/projects/shatypes">http://pgfoundry.org/projects/shatypes</a>/<br/> <a
href="http://pgfoundry.org/projects/sparsegraph">http://pgfoundry.org/projects/sparsegraph</a>/<br/> <a
href="http://pgfoundry.org/projects/prefix">http://pgfoundry.org/projects/prefix</a>/<br/> <a
href="http://pgfoundry.org/frs/?group_id=1000199">http://pgfoundry.org/frs/?group_id=1000199</a><br/> <a
href="http://pgfoundry.org/projects/pljava">http://pgfoundry.org/projects/pljava</a>/<br/> <a
href="http://pgfoundry.org/projects/dbi-link">http://pgfoundry.org/projects/dbi-link</a>/<br/> <a
href="http://pgfoundry.org/projects/pgbuildfarm">http://pgfoundry.org/projects/pgbuildfarm</a>/<br/> <a
href="http://pgfoundry.org/projects/pgspy">http://pgfoundry.org/projects/pgspy</a>/<br/> <a
href="http://pgfoundry.org/projects/wikipedia">http://pgfoundry.org/projects/wikipedia</a>/<br/> <a
href="http://pgfoundry.org/projects/configurator">http://pgfoundry.org/projects/configurator</a>/<br/> <a
href="http://pgfoundry.org/projects/postbio">http://pgfoundry.org/projects/postbio</a>/<br/> <a
href="http://pgfoundry.org/projects/mysqlcompat">http://pgfoundry.org/projects/mysqlcompat</a>/<br/> <a
href="http://pgfoundry.org/projects/osxpgpkg">http://pgfoundry.org/projects/osxpgpkg</a>/<br/> <a
href="http://pgfoundry.org/projects/docbot">http://pgfoundry.org/projects/docbot</a>/<br/> <a
href="http://pgfoundry.org/projects/pgnixinstaller">http://pgfoundry.org/projects/pgnixinstaller</a><br/> <a
href="http://pgfoundry.org/projects/pgcluster">http://pgfoundry.org/projects/pgcluster</a>/<br/> <a
href="http://pgfoundry.org/projects/fulldisjunction">http://pgfoundry.org/projects/fulldisjunction</a>/<br/> <a
href="http://pgfoundry.org/projects/plscheme">http://pgfoundry.org/projects/plscheme</a>/<br/> <a
href="http://pgfoundry.org/projects/pgsqlrpms">http://pgfoundry.org/projects/pgsqlrpms</a>/<br/> <a
href="http://pgfoundry.org/projects/ignite">http://pgfoundry.org/projects/ignite</a>/<br/> <a
href="http://pgfoundry.org/projects/biopostgres">http://pgfoundry.org/projects/biopostgres</a>/<br/> <a
href="http://pgfoundry.org/projects/tablelog">http://pgfoundry.org/projects/tablelog</a>/<br/> <a
href="http://pgfoundry.org/projects/enumkit">http://pgfoundry.org/projects/enumkit</a>/<br/> <a
href="http://pgfoundry.org/projects/livecd">http://pgfoundry.org/projects/livecd</a>/<br/> <a
href="http://pgfoundry.org/projects/reflectr">http://pgfoundry.org/projects/reflectr</a>/<br/> <a
href="http://pgfoundry.org/docman/?group_id=1000078">http://pgfoundry.org/docman/?group_id=1000078</a><br/> <a
href="http://pgfoundry.org/projects/plpsm">http://pgfoundry.org/projects/plpsm</a>/<br/> <a
href="http://pgfoundry.org/projects/mysql2pgsql">http://pgfoundry.org/projects/mysql2pgsql</a>/<br/> <a
href="http://pgfoundry.org/projects/pllolcode">http://pgfoundry.org/projects/pllolcode</a>/<br/> <a
href="http://pgfoundry.org/projects/dblink-tds">http://pgfoundry.org/projects/dblink-tds</a>/<br/> <a
href="http://pgfoundry.org/projects/mssqlsupport">http://pgfoundry.org/projects/mssqlsupport</a>/<br/> <a
href="http://pgfoundry.org/projects/autograph">http://pgfoundry.org/projects/autograph</a>/<br/> <a
href="http://pgfoundry.org/forum/forum.php?forum_id=344">http://pgfoundry.org/forum/forum.php?forum_id=344</a><br/> <a
href="http://pgfoundry.org/projects/pgtune">http://pgfoundry.org/projects/pgtune</a>/<br/> <a
href="http://tpc.org/tpcw">http://tpc.org/tpcw</a>/
<br /><a
href="http://tpc.org/miscellaneous/TPC_W.folder/TPCWFAQ0802.htm">http://tpc.org/miscellaneous/TPC_W.folder/TPCWFAQ0802.htm</a>
<br/><a href="http://pgfoundry.org/projects/tpc-w-php">http://pgfoundry.org/projects/tpc-w-php</a>/<br /> <a
href="http://pgfoundry.org/projects/qbe">http://pgfoundry.org/projects/qbe</a>/<br/> <a
href="http://pgfoundry.org/projects/pgbulkload">http://pgfoundry.org/projects/pgbulkload</a>/<br/> <a
href="http://pgfoundry.org/projects/pgfiledump">http://pgfoundry.org/projects/pgfiledump</a>/<br/> <a
href="http://pgfoundry.org/projects/pginstaller">http://pgfoundry.org/projects/pginstaller</a>/<br/> <a
href="http://pgfoundry.org/projects/oracle-fdw">http://pgfoundry.org/projects/oracle-fdw</a>/<br/> <a
href="http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/pagila/pagila">http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/pagila/pagila</a>/<br
/> <a href="http://www.pgfoundry.org/projects/pgcluster">http://www.pgfoundry.org/projects/pgcluster</a><br /> <a
href="http://pgfoundry.org/projects/emaj">http://pgfoundry.org/projects/emaj</a>/<br/> <a
href="http://pgfoundry.org/projects/pgjob">http://pgfoundry.org/projects/pgjob</a>/<br/> <a
href="http://pgfoundry.org/projects/npgsql">http://pgfoundry.org/projects/npgsql</a><br/> <a
href="http://pgfoundry.org/projects/skytools">http://pgfoundry.org/projects/skytools</a>/<br/> <a
href="http://pgfoundry.org/projects/pg-migrator">http://pgfoundry.org/projects/pg-migrator</a>/<br/> <a
href="http://pgfoundry.org/projects/python">http://pgfoundry.org/projects/python</a>/<br/> <a
href="http://pgfoundry.org/projects/ip4r">http://pgfoundry.org/projects/ip4r</a>/<br/>(92 rows)<br /><br /><br />I'm
inclinedto follow this request, except if someone point out a valid <br />reason not to do this. Or if someone has a
betteridea.<br /><br /><br />Thanks,<br /></pre></blockquote></div><br /> -- <br /> Sent from my Android device with
K-9Mail. Please excuse my brevity.
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