Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jSOa0-000420-Pz for pgsql-docs@arkaria.postgresql.org; Sat, 25 Apr 2020 17:27:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jSOZz-0006sL-95 for pgsql-docs@arkaria.postgresql.org; Sat, 25 Apr 2020 17:27:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jSOZy-0006sE-Vp for pgsql-docs@lists.postgresql.org; Sat, 25 Apr 2020 17:27:03 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jSOZr-0007ew-Rv for pgsql-docs@lists.postgresql.org; Sat, 25 Apr 2020 17:27:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:To:Subject:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=DpSvgi+rEknConUs5Se8bPgqWXc8QNejE+su8Z31H9o=; b=pHwx8IPIHE2RpCY1VL6x4iyZoF tXegmtpHMmdRGc3ZIX3LKsei+Dv45gY1PYoDgsPCjqaqNeSuoJhR4GORZXR2MHkmJ98IgVy2cTmnx QdBlxInpLSUHzA00PNb7+EHKav0KDxeADHwJQtf9psvE1gDGojLaegnLSfzU66H7I9AIyFY0bfG66 UdBCT78DSf1+dQesiK1H/VKywOpzaEvkjNgeMw0lPy/dnli1zmlNQIahjGEukz+15kOXHoQiQnPEW tuINNc5YSsfTVX4xYtEQJNKebU7w4KgaxhSzCDpLIItt+XOncXibGpNow2DAbeWCO6r3mNDM1TNWa xrOb1FWg==; Received: from pool-173-56-10-231.nycmny.fios.verizon.net ([173.56.10.231] helo=Ph33rHippo.local) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jSOZn-0001Jp-8U; Sat, 25 Apr 2020 17:26:54 +0000 Subject: Re: List of pages from versions 9, 10, and 11 that don't exist in "current" To: Michael Christofides , pgsql-docs@lists.postgresql.org References: From: "Jonathan S. Katz" Autocrypt: addr=jkatz@postgresql.org; keydata= mQINBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABtCdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz6JAlQEEwEIAD4CGwMFCQeGH4AFCwkIBwIG FQoJCAsCBBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCW1KJJQAKCRDxBJxy nxxlJwjrD/kBgqsW4QpNpTFw7ifRokZV08CCX4huPBJQ91rrv+UEWlEcotFBHVkYyHnpzARl tcZxhJ9CbFxjniH9cOTty5T/O1yolbOHtZSW8Z8aWV6BVEbjMb+BFxSSLm7RnvJdzQbGCZq2 ZZvfVpB6z3EHYph4KDdVKvMFjoLskxmdS1DE0tE3zTxvoQsi24Q+HOS07kUjs6fsu/WICMfz mgO++AWG9Y0CvN0mm4TkujESzyKM9E5irD+leEMIcddl51Aa2c/VMfBXQbRmpHIgUFTmuHQD CnQih+9i3OJAksDg66SP8a7yiXv5mwvyDi1EfTGVKYR2j+pwyjwnC3oIbvDMmB3uTn2JIjnT iZKPVtAcAylXjubFltihQgNyuShdP4W+kBwZizhUFqUVL8Anx+KoytYmJPfMRFLGuK4obXKq a2ZS3k9KB+H+isOx2nFJOsc7V360Zp1DVaNmuiK10TT6QndShSPaqkJqFtCb6r92rZ9sZM/L 3vtCI4Rrl3Pt1MgtENXupS8gZpJnAYS0j5A1PAZ09r6ANoaeMHspF+5J5fOHeEvqphXr36mm a83Vl1t4orPb0+QmmijmlpseDU63M88Aw5p3c4qj7t8Qr2EZ5zrn7/sFn5wOfbs8Nymxafif QCnlV2vg9p0m7vSk/yLJ4PFZvs52FgqAGRCdRn0s2EC99bkCDQRbUocAARAAv8ho/toQ9DG3 j4f9h9n1aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR 9u6qbOXcdqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq5 0wBW433eTvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAb jX1RiCw9gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSp vfm9eM0uSLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6 x44Wfsx8S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36Z Mroi9XMxg3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+7 0zpKJ10cc7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrd faKZYX2GMZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444X XTuLaP8j2mgcMvYak3ScCykAEQEAAYkCPAQYAQgAJhYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUn BQJbUocAAhsMBQkHhh+AAAoJEPEEnHKfHGUnReMP/RA2UhGQj+G4uBshkRLjpRysabdPqgQB dEBk6wYbio88Wg/2/hgY7UzmDDEwX3sZfQDcrI6+vIobI8uqstZID+WgAAa1JLfChMyVQnSy 0zfWMOABXscc5tGuvFRZvJklTissMFjXUwaREEKp4ZikTvJ/62MCjSdtrUhnPLvoTsHTKRKD ichE+b5A54alwsubTijw12O6N22r5IjZiiSZV0u7dsShyKw+7wCSax9fuBoE43NMYf+dnjMK nerAQYUcZWYMnk+EC8RaqYAxv6XZ2tKx1AkGGktwkQIBwrz9IlDSvJ3LWJ2UIIuLRTdngNgg GIL4zzuUa2F56FqskQIuYMaNETk6LYfalBDQ6TVLAcgCPQxp4k4i/PRsZ3lZ2ZhRHRYciOvm kp+I6EfHwllQpYrWs1thluBGqlJSVJgKl0IOFvKLsQ6KKfqzAwh6FxrO5qajp4viNIgtWoFw O5Bp0jgFTbH2OrMWIRfUdUCH1Djbuo65svhNj7FNsQVYzHDI+Nd1I/LOBoPc3UorRMF2M4JV kUR7skOHWUbPTSNUr7qc14NSMY3PKjGeVGAsBVHBPvmRx/Ss2tW/TpJWpxg4pmquFQSXuaYh Yf4FN8Sxy320pcr+FqN8AhZkYJcNY82OTtR5VEKRC/mYcyq61qXIKqngydn79bJjGxHipxyF FmEC Message-ID: <02b85282-f9e5-a428-8c4f-5a01729153e3@postgresql.org> Date: Sat, 25 Apr 2020 13:26:47 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="t258rhiE8ceEasq6gCSUp4zOBpfDleWZX" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --t258rhiE8ceEasq6gCSUp4zOBpfDleWZX Content-Type: multipart/mixed; boundary="TLezeqM15eAFgD5qbpu0qF5XOPfa6jrNf" --TLezeqM15eAFgD5qbpu0qF5XOPfa6jrNf Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 4/25/20 1:12 PM, Michael Christofides wrote: > Hi there, >=20 > Does anyone have an easy way of seeing which pages from the 9.x, 10, > or 11 docs don't have a "current" version? I don't have an easy way, but I have a pedantic way: 1. Set up the pgweb app[1] 2. Set up the requirements for the docload.py utility (tools/docs/docload.py) 3. Download the release source PG12 all the way down. You would really only need one, likely the latest (e.g. at the time of this writing 12.2, 11.7, ...) 4. Load each one into the database. You may need to explicitly create the "Version" objects in the admin for pgweb 5. Write SQL to see which filenames are present in an earlier version but not a later one. > For context, I've built a Firefox extension that redirects old > versions of the docs to their "current" version, except when either: > * you're already on the docs, or > * when a "current" version of the page doesn't exist. Sounds interesting. There is presently a patch[3] that could/should help to address this case. The challenge, outside of the file that was the impetus for the patch, would be finding the forwarding addresses for the new pages. I believe Step 5 in the above would help with that. Thanks! Jonathan [1] https://www.postgresql.org/developer/related-projects/ [2] https://www.postgresql.org/ftp/source/ [3] https://www.postgresql.org/message-id/4490e710-85f7-87a9-74dd-793d27440be= d%40postgresql.org --TLezeqM15eAFgD5qbpu0qF5XOPfa6jrNf-- --t258rhiE8ceEasq6gCSUp4zOBpfDleWZX Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAl6kctcACgkQ8QSccp8c ZSfUhBAAk/qknGtPNCr9g57gVNKofHyIcoZjsPuQ/kO/pc9dXaM9ZsicZSHHAO9M F00bvgvpj1ZBwKw1kX5PAahYeIBdfWfWrXO3xUkg8IPO1v0dlqkXPZWX3dO072fx OLiBUfT8XSlyJZr5d82gTPF6BO8qs92b0A7ij82fAqbYpCRuOXu7tQ2t2s/ataTX 84zK067eKXRac0qYFpkDs98s0R9tCFrswvnJe4Gmj5ZP+oknqenBgcqkUNpbJbV0 yxh4yVuwKJnRgV25FN+4OPXAHjBLNcZYXqTVKIm1QamCWszqJBMPdiIR+4nx+cWu WZx7sNJXNOpJ5U3OQmIa3j4TGD+y13a5k+mBiKbI2D301Y4cQYqYuT7443jUErxF hMk8s1cc68o8lsWQ3Q7cydqhp8DR6pnkF9b86AIyncuXKlsz9u65/J5fqWneyPKw YQjy8tVfeh70dcQghQxQBUzPbIX/CQIuvAekDxXkyqnIh5Ghmw+bqE0v6qehp9c6 wJSEO+BsI1IgvLhHzBFQuBVCWQWz+RB3knBhUpd62g+DQ3RBWNXK3iMTBZsybF7X EKq8XDYgjJldELirtJui5Gx4To5D4mxTeJjd3wbZdAejct++yoS8e1zscs3gsFB5 eUGPb32nicOtBNuyZJ/Z4bPgW6fEEomfT82hrgeifVjlMNh4QXY= =xNOR -----END PGP SIGNATURE----- --t258rhiE8ceEasq6gCSUp4zOBpfDleWZX--