Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKrYO-0001GF-JN for pgsql-www@arkaria.postgresql.org; Sun, 28 Apr 2019 21:41:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hKrYN-0000Qo-3a for pgsql-www@arkaria.postgresql.org; Sun, 28 Apr 2019 21:41:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKrYM-0000Qh-72 for pgsql-www@lists.postgresql.org; Sun, 28 Apr 2019 21:41:42 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKrYJ-00033J-K9 for pgsql-www@lists.postgresql.org; Sun, 28 Apr 2019 21:41:41 +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:Cc:To:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=qvzvded9QshoBh0bSI4oGJEvzZASLfyLydJeT4qhOYg=; b=mRl/OHi5uFhU2nXMHes9HFMopB O5v48p0fyixi+gKXpXMg0CaOBOpttbPkVBaKuIunEdXsZKkcRYHgGgHhnh+2IAHnuT2Iolot0oa27 711AWxl9OGizhgxs53D1Ql84plzMPnxjyOB1wpSt0ETTqKcfD6JxA5ujoJ/yYW754clSw7n4cpML8 Mz3xSaNaehV2gAA7BsLg9II3cq7AsKHhHyTkK+vdr7nY5sq0CpY2ptybDtwzACdqZTrvf6Bw1Xd+t pMBwX/t/he/4RyB8PzdJs4Dutdosc6uwRuKQb/D8ZwiLlDdqV0Wt/pB8o2P+0AnsOk/YKqlt/e5LR XCsJtiRA==; Received: from pool-96-250-83-19.nycmny.fios.verizon.net ([96.250.83.19] helo=Ph33r-Retina.home) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKrYG-000312-62; Sun, 28 Apr 2019 21:41:39 +0000 Subject: Re: BUG #15706: Support Services page out of date,Re: BUG #15706: Support Services page out of date To: Tatsuo Ishii Cc: daniel@yesql.se, magnus@hagander.net, euler@timbira.com.br, pgsql-www@lists.postgresql.org, jtara-github@spamex.com References: <847625e0-7726-0cf7-8c68-ec2500a07b45@postgresql.org> <20190429.063830.371372237913446079.t-ishii@sraoss.co.jp> From: "Jonathan S. Katz" Openpgp: preference=signencrypt 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: Date: Sun, 28 Apr 2019 17:41:30 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <20190429.063830.371372237913446079.t-ishii@sraoss.co.jp> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="2R9eYQMkGrqNQpUtmVtQ8Pp5kAJyMsE2Q" 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) --2R9eYQMkGrqNQpUtmVtQ8Pp5kAJyMsE2Q Content-Type: multipart/mixed; boundary="sd9W9O4rrf7cWsHbViLLPEycEk5HY49uj"; protected-headers="v1" From: "Jonathan S. Katz" To: Tatsuo Ishii Cc: daniel@yesql.se, magnus@hagander.net, euler@timbira.com.br, pgsql-www@lists.postgresql.org, jtara-github@spamex.com Message-ID: Subject: Re: BUG #15706: Support Services page out of date,Re: BUG #15706: Support Services page out of date References: <847625e0-7726-0cf7-8c68-ec2500a07b45@postgresql.org> <20190429.063830.371372237913446079.t-ishii@sraoss.co.jp> In-Reply-To: <20190429.063830.371372237913446079.t-ishii@sraoss.co.jp> --sd9W9O4rrf7cWsHbViLLPEycEk5HY49uj Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Hi Tatsuo, On 4/28/19 5:38 PM, Tatsuo Ishii wrote: >> On 4/26/19 11:48 PM, Jonathan S. Katz wrote: >>> On 3/25/19 5:33 AM, Daniel Gustafsson wrote: >>>> On Sunday, March 24, 2019 6:50 PM, Magnus Hagander >>>> wrote: >>>>> On Thu, Mar 21, 2019 at 1:20 AM Jonathan S. Katz >>>> > wrote: >>>>> >>>>> Some of the pgweb folks have discussed doing that before; it's = not >>>>> a bad >>>>> idea, and perhaps would cut down on some of the headaches. >>>>> >>>>> >>>>> That was in fact the original plan, nobody just got around to build= ing >>>>> it. There was even a db field for it in the early dev snapshots, bu= t >>>>> it was removed since it was never quite done. >>>>> >>>>> The general idea was to just have a "last confirmed" timestamp fiel= d >>>>> on each entry, and just stop showing any entries that have not been= >>>>> confirmed in days/weeks/months/whatever. We can keep them aroun= d >>>>> some extra time beyond that in case people come back to update them= >>>>> later of course. >>>> >>>> I think it makes sense to remove after a set timeout, if the user ha= sn't >>>> verified in 3 months (or some >>>> other sufficiently long period) then the odds that the entry is out = of >>>> date seems quite high. >>>> >>>>> Oh, and=C2=A0+1 for doing the same for products.=C2=A0 >> >> OK, so I did the scrub for products. >> >>> The scrub took me about 2 hours and change. >> >> Fortunately, products are a bit more straightforward and did not take = as >> long as services, though it was still at least an hour. So whatever >> system we put in place for services, I suggest the same for products >> >> There were 210 products listed at the beginning of the scrub. >> >> - 170 remain >> - 40 were removed as they did not exist + no obvious replacement / wen= t >> to things I wish I could unsee. >> >> I would say this was more stale than I thought too, but given that the= re >> has not been a product scrub as long as I can remember, it's not as ba= d >> as the staleness of the services. >> >> Regardless, let's work on getting that system into place to help manag= e >> it so scrubs are less gargantuan tasks. >=20 > Are we working on this region only? > https://www.postgresql.org/support/professional_support/northamerica/ I went through every organization that was listed, regardless of region. > Some of the companies listed in the northamerica page also appear in > other regions (I only checked aisa though). I think companies removed > from the northamerica region should also be removed from other regions > as well unless they explicitly stat that they have different entities > in the other regions. The pgweb schema allows for a professional service to be listed in all the regions it operates. I did not adjust that; I only removed organizations that were clearly no longer operating (based on above definition), and reached out to other orgs for clarifying questions. In the case of removal, the org was removed from _all_ regions. Thanks, Jonathan --sd9W9O4rrf7cWsHbViLLPEycEk5HY49uj-- --2R9eYQMkGrqNQpUtmVtQ8Pp5kAJyMsE2Q Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlzGHgoACgkQ8QSccp8c ZScn0w/+PFgakP8IYXrluPCGxR6QO/kxVIBFmR1q3ftYgfF5pep+xgTyjOKWmjgI SZXik3g605n6qzg20elKvnFfuZ2lovVsdFTskV02k/XpW9/fFs0dSayp9YFTmmwR qjLITDQiOLZYZWLAnwFDlsiUNEUO0IT8oO+xJQawbaUjVlJ1olP4wfb/qh93f8Ya LEJ66+y8XkFu3+QcynO7CS+dCKoP9vbSy9fIC70DBcfKZMYuDTm1VzYmQ4WZWn8A eIsH49Yby2BTKW5lIkBtBDxB4pFV28WqVbGCU1y/tO28uEiM4mQA0AI6tvHfIpfE 9belwmimFHNhSCYeadaMnY/68uLKbM7kSU2bou6h/QwLNYKzMIMne9Bdcc+mD4T1 I19D4X7VpZdHIVKsNwNntIBWFzhJLy9IQ2+LLv65Vtt68ADQb2lL5XCFzVEqskZY GXNXbD+mAIHNRP/10N3k1bbnoWNgKJfvN7UApNbdWRYGKETmWpfD/Ian0DGmMWtc bHZuxv0DzjsX5L6p4a6EXsC3BeyRW+rTOmYYobIVe2MQi0VMd+KotOlPWncw13AL gujecqAtddSpXHRCs6VY0miZZHwtlkMmH5t1FquKHEAtfsf28th3jzL02KzWADkY camVVJSXvhwKBxosP+f9AdnyVACjTo2k3aCfeBOHlZrAKitwCfE= =7PW0 -----END PGP SIGNATURE----- --2R9eYQMkGrqNQpUtmVtQ8Pp5kAJyMsE2Q--