Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6Asz-00HUBs-2v for pgsql-www@arkaria.postgresql.org; Thu, 23 Nov 2023 14:40:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r6Asx-00139z-QX for pgsql-www@arkaria.postgresql.org; Thu, 23 Nov 2023 14:40:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6Asx-00139r-ID for pgsql-www@lists.postgresql.org; Thu, 23 Nov 2023 14:40:55 +0000 Received: from mail-pg1-x536.google.com ([2607:f8b0:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r6Asu-006zMX-TX for pgsql-www@lists.postgresql.org; Thu, 23 Nov 2023 14:40:54 +0000 Received: by mail-pg1-x536.google.com with SMTP id 41be03b00d2f7-5c239897895so664068a12.2 for ; Thu, 23 Nov 2023 06:40:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hagander.net; s=mail; t=1700750452; x=1701355252; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=YEwJm3jOAevbzISHlOTaVOD5b4n5FYambc8G2LPvOzc=; b=ffYsF+52WTLGV8WhFkmJDBuqlnC9syRtN40uawadSY0W3Py0LCljrUVNvyflqkBjS9 AxkFgHiq4KlSj1XmKChdA/BcAQih3cJiiOuR4S3wtx5vV3rbc6/wBeN5grQffoAeR8ie YdfY8X77veo3YYnx1+Pd9UnYsXJ7HH5LnEzVAeqz4ArQqZpruz0xboMfk0jYSEgTIese bYbS+L93wAlqOPFTnbdAHCGE1m4t+Yf6g62EvcbfxLihz8ATTmgA9o7ez5WDOUP8JMeE D0QiBimJDHRc7u6PzChR+SzeUxGmm7LHWRhezkipuHf9X/v8p8UfE0KFefhnR+GeY8GU HPPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1700750452; x=1701355252; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=YEwJm3jOAevbzISHlOTaVOD5b4n5FYambc8G2LPvOzc=; b=Eo46WTrCnpaajVggi0l2C63utqt4JEbKmtICazZyqoV7QiB1ORD4WUf/sutSRJ1ftO OXm/9ajDbmQ+jh6KHeBGoXwktC+VmWH/0JSBuchbscbL2Q/WTESJtGhJ0WmAgIxfaP7D lHC8srI0dy3F5sS2DLawV9I1aBZ2TMIzUfWMtdISadl9X6FOanuNwQgwEBHvbtSLcjpQ vndFqRV8WR1Jh/tl7E9S/xqLzvLc/90GX5Q72oBm4JxsDByTJY8em2PbVWsEBKyTpQoT L39DUhRi6L0MLfj6twNUL7c+QO2Sp2inaipDv9vG7d1gYtHFn6gTIPsu5UHqT86a3DP5 GTHw== X-Gm-Message-State: AOJu0YweRcvsuOeocMFDiFAMFBkHPt4dLawtG7a6ZEEtol2TbiCB3LQM 8sltvNTE2Q8gVbX1nf2NF7jbJnP92rFuy7MxFOPayQ== X-Google-Smtp-Source: AGHT+IEdcVpxjX5HunXrKu1Gi88fkfqSHq1257ZPnqWD6mnfA45WpjeU1p0n1QHdAuIigwso3xeetylquOILtf4XXE8= X-Received: by 2002:a17:90b:4ace:b0:27c:f80a:2c8a with SMTP id mh14-20020a17090b4ace00b0027cf80a2c8amr5626536pjb.0.1700750451968; Thu, 23 Nov 2023 06:40:51 -0800 (PST) MIME-Version: 1.0 References: <20230904105958.s45oaei7x3te37e4@alvherre.pgsql> <7fbfadbb-58e6-4e35-83b3-37465f602d11@pgug.de> In-Reply-To: <7fbfadbb-58e6-4e35-83b3-37465f602d11@pgug.de> From: Magnus Hagander Date: Thu, 23 Nov 2023 15:40:21 +0100 Message-ID: Subject: Re: New blog - who dis? To: "Andreas 'ads' Scherbaum" Cc: Alvaro Herrera , pgsql-www@lists.postgresql.org, planet@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Nov 20, 2023 at 11:44=E2=80=AFPM Andreas 'ads' Scherbaum wrote: > > On 11/09/2023 16:09, Magnus Hagander wrote: > > On Mon, Sep 11, 2023 at 8:01=E2=80=AFAM Andreas 'ads' Scherbaum wrote: > >> > >> > >> On Tue, Sep 5, 2023 at 2:16=E2=80=AFPM Magnus Hagander wrote: > >>> On Mon, Sep 4, 2023 at 2:47=E2=80=AFPM Andreas 'ads' Scherbaum wrote: > >>>> > >>>> > >>>> On Mon, Sep 4, 2023 at 1:00=E2=80=AFPM Alvaro Herrera wrote: > >>>>> Hello, > >>>>> > >>>>> On 2023-Sep-04, Andreas 'ads' Scherbaum wrote: > >>>>> > >>>>>> I plan to migrate my blog to a new software platform, which > >>>>>> will also change the URLs which appear in the RSS feed. There > >>>>>> is no convenient way to keep the old URLs in place. > >>>>>> > >>>>>> Most importantly, this will affect Planet PostgreSQL, which > >>>>>> suddenly might see about 150 "new" blog postings. > >>>>>> > >>>>>> Is there a recommended way how to deal with such a move? > >>>>> Each post in the blog has a "guid" unique identifier, which is usua= lly > >>>>> the same as the URL, but some platforms let you set up something > >>>>> different. If you can "migrate" your posts to the new platform whi= le > >>>>> keeping the GUIDs, that would be best -- they would not be seen as = new > >>>>> posts. The actual URLs don't actually matter. > >>>> > >>>> The guid in my case is the full URL of the posting, including the do= main. > >>>> I would need to break and fix quite a few things to port this guid o= ver to > >>>> the new system, and I can easily miss something before going live. > >>> You wouldn't need to keep the URL for the new posts, only the GUIDs. > >>> That is, new posts could have GUIDs in a new format, old posts could > >>> just use the old URL in the GUID and the new URL in the, well, URL. > >> > >> That's a theme change which I more or less permanently need to > >> maintain. I'd avoid that, if possible. > >> > >> > >>>> I'd rather not go down this path. > >>> Strictly speaking, per the RSS requirements, you have to. Not donig > >>> so will cause reposts for anybody *else* who is tracking your RSS fee= d > >>> as well, not just Planet PostgreSQL. > >> > >> Correct, but I'm mostly worried about spamming Planet. > >> > >> > >>> * No posts older than 7 days will get posted to *twitter*. They only > >>> go in the planet RSS feed(s). > >>> * The planet RSS feeds contain 30 items. The homepage as well. At thi= s > >>> point you can see this goes back to Aug 24, so not very far. That > >>> means that any entries older than that will be ingested into the > >>> system, but they won't actually be shown to anybody. > >>> * The feed passed through to www.postgresql.org further restricts thi= s > >>> to just the past 10 > >>> > >>> So this would indicate that if you have a period of say 2 weeks of no > >>> postings, *planet* won't notice. Others might. > >> > >> Basically not posting to Planet from this blog for 2-3 weeks, and mayb= e > >> giving someone a heads-up should do the job? > > > > Yes. Note the date of your last post and keep an eye out on > > planet.postgresql.org and make sure that date has "scrolled off the > > end". Once it has, and it's >7 days, then you are safe from a planet > > perspective. > > Well, can report that I made sure that the old feed url sends a 301 > (permanently moved) to the new feed url. > > However Planet doesn't like this: > > Feed returned redirect (http 301) > > And marks the request as "Failure". > > Looks like the new feed url must be updated (and then the blog goes into > review). Yeah, this is normal -- planet only autodiscovers redirects to the https version of the same one. If you change the contents of the URL, it will get sent back for moderation. (For the *RSS* that is - any *links* will of course be followed, because that's done by the browser) //Magnus