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 1urHBg-003Riu-7y for pgsql-general@arkaria.postgresql.org; Wed, 27 Aug 2025 14:31:45 +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 1urHBf-00Fks8-Dl for pgsql-general@arkaria.postgresql.org; Wed, 27 Aug 2025 14:31:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1urHBf-00Fkrz-3H for pgsql-general@lists.postgresql.org; Wed, 27 Aug 2025 14:31:43 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1urHBd-0029jo-0M for pgsql-general@lists.postgresql.org; Wed, 27 Aug 2025 14:31:42 +0000 Received: by mail-oi1-x22c.google.com with SMTP id 5614622812f47-435d3a45a3fso502921b6e.1 for ; Wed, 27 Aug 2025 07:31:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756305097; x=1756909897; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=yGcjvAyOYuW6DsYI3HtRLeP6y4ed8WTMaR/5pGRTs/U=; b=OMnwAe9n5Fpz6S4eNRwvatAt47GpBnCmTINXYZaTLMZSPTKHOdAKPZyt1g73uYZE9S iy31ITO0nvvb//fByaININooANrVd9y9WMC9oTfyL99ckOX3qi6cAbVeX0CoxXY6gxAF LW1KI/8oTV3zeVeVAjZNkwLwsjYIqkL/bBj+/UhAlU4ySZbfLyLt7DwExSoXlZP3lWZL mqQN+rKi8j8iJI+J3J8eSLp6dOKVPX7TSGUq5d9olaW6Pf9M8hdTLX5PBGLD72jjGMwG 30oAYKOBvmBI6yJlvkuaTHG/lK1aUmTunOee/XWyfqjd/wyzX3XyS5ldu0wtbcaa3Dlx nP7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756305097; x=1756909897; h=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=yGcjvAyOYuW6DsYI3HtRLeP6y4ed8WTMaR/5pGRTs/U=; b=Sm56KP0TZUUFNOdzml7QK+OUTCgBTZgEgmt/y6ktSeeTf7ny9sFW4o95rcP45MMqGr HJ7oNuKFWIjeL3LZnpOrZdU/k3qMzVkKSuRJp/DjwMg/18CjkOUyzixt3jXFNpBVf9SB L4J3VAT2zeNJeR4h0jdDdip/MGH5QIsGE32Idth+Nl6SI0Hn5kIt5R0URHDezYHIZsPM gPjNK7O+Wr/Riim09VZhXFpO7RUIr2iGpkErpYpwuUcdmhoGhfeBHmHt/GhEM8YUeKjN 7edUFN9yGgoOqNfHAH6+P43D34nKQ4Y8ow/lS35t4a9PKx41jd7KTO7dpXPBoR2FX7bC s7Gw== X-Gm-Message-State: AOJu0YyjlyRLC4nmXpB8i8FSUdloqwDpirYyR+a/Va9VMcIWinq1v1pO ssO/oFplO7DvabVlJ/asCUEPajbqCUNp5wOP+nyZA4mutUU+KE75zNBXU1vRMYcw0efC59c9Ma0 aeTCXcjzf/TuIztuAeZVVnB01CTBGpHVziA== X-Gm-Gg: ASbGncvKd7m0zttJWNeVTjwbwXiQPa79gRAAc+FJbGE/1euvrBUsvyIG6haJ7KraahX K+SyNemfSixo5EUmWp7cvz/nfx3C8kfbjmj2ajyxZZlg5J0KNyMqddW7wF9n61Lht7hpnL92NXa u1u2sMXWmXRZSkhAHyOhdgEbpQfTv6J1i9c8cUmtTCtfcyX3Apq3SHQUDTt0sPxF78/btWLW9I0 S6JjlQz X-Google-Smtp-Source: AGHT+IFI5vFQGKjKc4KNVEPfvB9ynCpddVJQd4IjdFm2qtgsRjD6fPyl8WbkQfV/pVPn70watCE2TAIkBDBwnQD/C7M= X-Received: by 2002:a05:6808:1822:b0:437:75ea:6c73 with SMTP id 5614622812f47-437c543fa05mr2670649b6e.22.1756305096852; Wed, 27 Aug 2025 07:31:36 -0700 (PDT) MIME-Version: 1.0 References: <3541781s-75o7-26pp-46pp-qs54o4406192@tzk.arg> <1389082.1756304193@sss.pgh.pa.us> In-Reply-To: <1389082.1756304193@sss.pgh.pa.us> From: Ron Johnson Date: Wed, 27 Aug 2025 10:31:24 -0400 X-Gm-Features: Ac12FXycU43ef8bBr5b8qGMD7OXJvgBPoTvKpBkwqUF1EoN1u8wZQmJu6_4wthI Message-ID: Subject: Re: In-order pg_dump (or in-order COPY TO) To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006a4b24063d59a55d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006a4b24063d59a55d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Aug 27, 2025 at 10:16=E2=80=AFAM Tom Lane wrote= : > Dimitrios Apostolou writes: > > Dump is from PostgreSQL 16, it's pg_dump writing to stdout: > > > pg_dump -v --format=3Dcustom --compress=3Dnone --no-toast-compression > --serializable-deferrable db_name | borg create ... > > Don't use --format=3Dcustom (and not -v either). That causes pg_dump to > include the OIDs and pg_dump object IDs of all the tables and other > objects, That's interesting. Why? (Since isn't it supposed to be Bad to rely on OIDs?) --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000006a4b24063d59a55d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Aug 27, 2025 at 10:16=E2=80=AFAM = Tom Lane <tgl@sss.pgh.pa.us>= wrote:
Dimitrios Apostolou <jimis@gmx.net> writes:
> Dump is from PostgreSQL 16, it's pg_dump writing to stdout:

> pg_dump -v --format=3Dcustom --compress=3Dnone --no-toast-compression = --serializable-deferrable db_name=C2=A0 |=C2=A0 borg create ...

Don't use --format=3Dcustom (and not -v either).=C2=A0 That causes pg_d= ump to
include the OIDs and pg_dump object IDs of all the tables and other
objects,

That's intere= sting.=C2=A0 Why?=C2=A0 (Since isn't it supposed to be Bad to rely on O= IDs?)

-- =
Death to &l= t;Redacted>, and butter sauce.
Don't boil me, I'm still aliv= e.
<Redacted> lobster!
--0000000000006a4b24063d59a55d--