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 1hKNQu-0003yv-KH for pgsql-www@arkaria.postgresql.org; Sat, 27 Apr 2019 13:32:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hKNQt-0005yy-CX for pgsql-www@arkaria.postgresql.org; Sat, 27 Apr 2019 13:31:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKNQt-0005ux-2G for pgsql-www@lists.postgresql.org; Sat, 27 Apr 2019 13:31:59 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hKNQq-0004cw-NJ for pgsql-www@lists.postgresql.org; Sat, 27 Apr 2019 13:31:57 +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=Wsm86oYLQRs8KMadjCBmEATNy+aYX4ggBw/SMGUJ4x4=; b=MGbEWeoZwn546Sy+C6ZZizZl7K HFJs8yV0pGzhiXuJFWzjfNMOUosTMyns1JMc5JyFJd6GUwuKHFNCLTChlXWFueQQmGdxSdhP3TLWs ZVvCdQfK11v0yEBLGX9mHyJJl+K9P9owNjzuP8MwVUhsNssVRs8XX3rOe6Rbo65bZ0DblKXxUbPhH zyujF97z6ZUwV1wtMN5UBmeSHtUlV1TJrsiEZ+CwmjSKRmbla4QDUgVXRJQibpQvfRzV8ll+AGMS6 qrIhTGIupGwczWOEHOgwChYs7RzQ8nI8Ww1jpPcZiR5x/qdaJe+N+IYxS+9svBTGOhT0P6Klnx6Dc CtSsaFOg==; 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 1hKNQm-0006YK-VT; Sat, 27 Apr 2019 13:31:55 +0000 Subject: Re: BUG #15706: Support Services page out of date To: Magnus Hagander Cc: Daniel Gustafsson , Euler Taveira , PostgreSQL WWW , "jtara-github@spamex.com" References: <15706-8ded5d7a37af6278@postgresql.org> <9ef787c5-62a9-c0a3-6261-5ef4863c78d3@postgresql.org> <847625e0-7726-0cf7-8c68-ec2500a07b45@postgresql.org> 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: <88dabc4f-ac7d-1c0c-5eaf-58992937c3ac@postgresql.org> Date: Sat, 27 Apr 2019 09:31:50 -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: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="N9LtDueHBnw2SBFEboJvxkGgSG1XP3rSh" 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) --N9LtDueHBnw2SBFEboJvxkGgSG1XP3rSh Content-Type: multipart/mixed; boundary="fLtSeRblaoVtcJYF9iRM7vxdolGtKZ6nk"; protected-headers="v1" From: "Jonathan S. Katz" To: Magnus Hagander Cc: Daniel Gustafsson , Euler Taveira , PostgreSQL WWW , "jtara-github@spamex.com" Message-ID: <88dabc4f-ac7d-1c0c-5eaf-58992937c3ac@postgresql.org> Subject: Re: BUG #15706: Support Services page out of date References: <15706-8ded5d7a37af6278@postgresql.org> <9ef787c5-62a9-c0a3-6261-5ef4863c78d3@postgresql.org> <847625e0-7726-0cf7-8c68-ec2500a07b45@postgresql.org> In-Reply-To: --fLtSeRblaoVtcJYF9iRM7vxdolGtKZ6nk Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 4/27/19 6:41 AM, Magnus Hagander wrote: >=20 >=20 > On Sat, Apr 27, 2019 at 5:48 AM Jonathan S. Katz > wrote: > This is also a long way of saying that I think we should proceed wi= th > the solution to help automate this. After going through the painsta= king > process again, I'd recommend it works kind of like this: >=20 > - An email goes out once every {6 months, 1 year} to the organizati= onal > contact that says something like: "Hi, This is an automated check t= o > ensure your company is still an active PostgreSQL service provider.= > Please click the URL provided to confirm. If you do not= > confirm within 7 days, your listing will be unpublished" >=20 >=20 > 7 days might be a bit on the short side. If someone is unlucky they get= > the notification while on vacation for example, and then they're > delisted before they can even see it. Well, that's why I suggested it gets de-listed, so one of us can manually check and determine if indeed it should be delisted, or it's the case of out-of-office, or a bad email address, etc. > - If user clicks URL, it is confirmed and the last_confirmed_date i= s set > to CURRENT_DATE >=20 > - If user does not click URL, we set the entry to unpublished. This= > would put it into the moderator feed, and one of the pgweb moderato= rs > can then take further action if need be. >=20 >=20 > That's pretty close to my original thoughts around that, except I'd jus= t > delete them as step 3 and not bother the queue.=C2=A0 I'm fine with > de-listing it as well, as long as pgweb moderators are happy to handle > that :) That would also take care of the scenario where the email > bounces, by simply being able to ignore that fact and leave it up to th= e > individual moderator to handle manually. I would de-list it. It's certainly easier for a moderator to check a few of said entries vs. the whole slew. > Anyway, products needs a scrub as well, which I will try to block o= ut > some time for in the coming days to handle those as well. Those sho= uld > hopefully not take as much time as they are a bit easier to verify.= >=20 > Cool. Thanks! NP, feels good to do some spring/fall cleaning :) Jonathan --fLtSeRblaoVtcJYF9iRM7vxdolGtKZ6nk-- --N9LtDueHBnw2SBFEboJvxkGgSG1XP3rSh Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlzEWcYACgkQ8QSccp8c ZSezaw/+JDJdXn327EtuUL3pAVTpUBCoAMg6gpmNqA/KhBGVRUKDVlonMe2gGDfP 19cWjBrUio96gc6qQb9OLEjUnXIA97IWS/CKadwiediYJtWBamPiiaCjoz07IXC2 dxABruWv5cFgkmvpAWLemYasPRIiD70SMCSlf6tKCijbqxZGb2f45q3KXhLVi991 OD/K6vhgXXeF5zNdll3K4FBFT5SCIIpy10VD3DDqXgYjcl4Z8YcYJM0X3Nc2wXB7 JS5edcy949AOHHdW/gJhF96prHuItakhDvIqsz5ExLKgEXiCRSreJ6ge1jderBhe 8LsnhccoghkzMEe39tFo8eDAcS+4kuy9Q2GRn2FXgVVXu4Ca82J7R0xnZ/4BBJit r0Ri7bOAmVtkjqMKU2UnafUp4aXFbyZw7wast3uy94Sji0AviwsqPRZ4wdziLdEd CS2L17Lopz22rGWVPdr4IgDBB5LEUTykeQW1HQixl2pykUjsOiY6iK1TzMufyY9+ nHSR838cA06Ubthf7dH1Cv3gd6mdguWszt6+HaUQN+0Zo/ebTf5pAaSOsARuA3Qf S/ScM9W7Fjj4XBWlMSXONcCxsq68IuImJBKX2UzcfPK6u6kYG+NI3M5kFhh6Q5Ev ssIZFFuBycwxPFD2YAa4Gyb/0jbWbysJmTt7m+xlLRGPCZj/zOc= =t6LZ -----END PGP SIGNATURE----- --N9LtDueHBnw2SBFEboJvxkGgSG1XP3rSh--