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 1qd8zd-002Kcz-TV for pgsql-www@arkaria.postgresql.org; Mon, 04 Sep 2023 12:47:50 +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 1qd8zc-00BHVN-Nd for pgsql-www@arkaria.postgresql.org; Mon, 04 Sep 2023 12:47:48 +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 1qd8zc-00BHV1-8b for pgsql-www@lists.postgresql.org; Mon, 04 Sep 2023 12:47:48 +0000 Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qd8zY-002gTX-90 for pgsql-www@lists.postgresql.org; Mon, 04 Sep 2023 12:47:46 +0000 Received: by mail-pf1-x430.google.com with SMTP id d2e1a72fcca58-68c0d262933so682039b3a.0 for ; Mon, 04 Sep 2023 05:47:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgug.de; s=google; t=1693831662; x=1694436462; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=E52mAwBnDUq1r7GOywk0D1iEGpKfWnZ7SSAAPJVOkhg=; b=Cm2wyD8dX2Sl/i3GHcPKbLlSrRnVkQYm66nsm0PaZIsNsQ6l86MZuSqnPWTI+9R7vB 5GPR6NVhsTLK8svqlB+Tv6X47NSmeEoa/MNbXBarBsg5uvwBm68RmN7uOGpPvk0TN987 CIMV7wK4HvvrQhMHUUH3Cra5WlpdVXeo2tj24mM0ZBOyA50ozA9BFE8wf+5I3nERkdQU Ijw0SJu9OuvE2MYglJ/S+VS+U7HHYQnmRs5EZ+7M/Qn/qVd8FG3wM9gVQyibmBr+YlxZ A81Q2nmRngLgOfFaSTXzUX3iIn5/LdR6vdAxjapOksPGynxhBRS7cu6BTB8/9PPnbuT7 liWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693831662; x=1694436462; h=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=E52mAwBnDUq1r7GOywk0D1iEGpKfWnZ7SSAAPJVOkhg=; b=AcH+D6CnxyJM7Fy2KKkBvpyS0ErajViA/8HelRRxsSvu7+E/CoI7nb8xQD4Lb9XYAH 791uEdZ1PLb8VAqm2+vA/Z+4pfYnKRU8xjuBI2dmy9n/OI2O1waUDbmyq8LCWLYAM7Bh HRtPMbsYE1n3HCkCW4BnNost5EXT5YiOCIMbj1wyPxevoUj7UEeajVHii9CffYqHITSF VUssjxW1NfwtW35YwiA+QQqO9yJKasztls6BKE76GhXtrOoxVUO1NtwvtkEYEDhXhf42 z4c+p1nLEJijD8FAJ9jX4WlgtIEIXc0KaUdIrXT772HVjH5xI44VPJ51QJ8xy20ZW1CL MsAA== X-Gm-Message-State: AOJu0YxckAQW97vp0rao3mQy+M0xBodn1br3+buKFq+VTwSIorxvSFug Y5gTV3/P1w5J9JIpTZLkwTOaBHPJnwDmklqEC7eUUA== X-Google-Smtp-Source: AGHT+IEB1+/DIGiDh8B2qdJ/NiZ0x+5QFr1KqmGHfLvhtbomMK0bU59nYgKf1MBkYJA9SX/kIcazyUdXrQWCUMn6wlY= X-Received: by 2002:a05:6a00:b95:b0:68b:daf4:212f with SMTP id g21-20020a056a000b9500b0068bdaf4212fmr9434571pfj.21.1693831662190; Mon, 04 Sep 2023 05:47:42 -0700 (PDT) MIME-Version: 1.0 References: <20230904105958.s45oaei7x3te37e4@alvherre.pgsql> In-Reply-To: <20230904105958.s45oaei7x3te37e4@alvherre.pgsql> From: "Andreas 'ads' Scherbaum" Date: Mon, 4 Sep 2023 14:47:25 +0200 Message-ID: Subject: Re: New blog - who dis? To: Alvaro Herrera Cc: pgsql-www@lists.postgresql.org, planet@postgresql.org Content-Type: multipart/alternative; boundary="000000000000894b7c060487ead5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000894b7c060487ead5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 usually > the same as the URL, but some platforms let you set up something > different. If you can "migrate" your posts to the new platform while > 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 domain. I would need to break and fix quite a few things to port this guid over to the new system, and I can easily miss something before going live. I'd rather not go down this path. > If your platform doesn't let you do this, I think PlanetPostgres would > mark the new posts as hidden anyway, because of the volume (but pester > everyone along the way). That way only future new posts (actually new > posts) would be syndicated, but everything would appear duplicate in the > admin interface. > Will it work if I disconnect the old blog from Planet, then move the software and apply the blog again? Will this ingest all previous postings on the feed, or just the new ones? > > Did someone do such a move before, what is your experience? > > It's usually a pretty noisy things to do, from the moderators point of > view. > That's exactly what I want to avoid. Thanks --=20 Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project --000000000000894b7c060487ead5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Sep 4, 2023 at 1:00=E2=80=AFP= M Alvaro Herrera <alvherre@al= vh.no-ip.org> 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 us= ually
the same as the URL, but some platforms let you set up something
different.=C2=A0 If you can "migrate" your posts to the new platf= orm while
keeping the GUIDs, that would be best -- they would not be seen as new
posts.=C2=A0 The actual URLs don't actually matter.

The guid in my case is the full URL of the posting, includ= ing the domain.
I would need to break and fix quite a few things = to port this guid over to
the new system, and I can easily miss s= omething before going live.

I'd rather not go = down this path.


=C2=A0
If your platform doesn't let you do this, I think PlanetPostgres would<= br> mark the new posts as hidden anyway, because of the volume (but pester
everyone along the way).=C2=A0 That way only future new posts (actually new=
posts) would be syndicated, but everything would appear duplicate in the admin interface.

Will it work if I disc= onnect the old blog from Planet, then move the software
and apply= the blog again? Will this ingest all previous postings on the
fe= ed, or just the new ones?


=C2= =A0
> Did someone do such a move before, what is your experience?

It's usually a pretty noisy things to do, from the moderators point of<= br> view.

That's exactly what I want to= avoid.


=
Thanks

--
Andreas 'ads' Scherbaum
German Postgr= eSQL User Group
European PostgreSQL User Group - Board of Directors
V= olunteer Regional Contact, Germany - PostgreSQL Project
--000000000000894b7c060487ead5--