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 1sEW2K-001sad-5u for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 15:25:21 +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 1sEW2K-000GQw-8s for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 15:25:20 +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 1sEW2J-000GQf-UP for pgsql-general@lists.postgresql.org; Tue, 04 Jun 2024 15:25:19 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sEW2H-003Q9x-IG for pgsql-general@postgresql.org; Tue, 04 Jun 2024 15:25:18 +0000 Received: by mail-oi1-x22f.google.com with SMTP id 5614622812f47-3d201f9a55dso208248b6e.3 for ; Tue, 04 Jun 2024 08:25:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717514717; x=1718119517; darn=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=JVXXuqjjith3FY9z9hy/FLlBnFwx1TJFJVy1qlbIhy8=; b=jh71nXXS9yVjsARA4mfe1hHDe6qAqVfHeIFAplA6DzIkRCugnLdiVrq7mib71b+Vsg AFxeggUPd8mfuM2dHrLTgtf0N/meLB6CLXbu9m9h8GTe0WDRgNcLKydIOEPgAwxYwntq /+tF1e7iziCJfVCv9mqxnTmvuKcf2Hyrte3bf8Q6GgCVJWxDd6t4MecsGZC4u6XxXw8k INCwtwSSddJihiylyAtyAq1sR7kUsMUNbgucyQfqQxwN7GK/bSP3Cc46yWI+vFzHavY5 XoIJyP4TiODm8vMZ9E3e6YorktZCk6V9Osya7hPyyaA4NV9fQY7ZmzTnbxz39b6Mqbss uemA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717514717; x=1718119517; 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=JVXXuqjjith3FY9z9hy/FLlBnFwx1TJFJVy1qlbIhy8=; b=daQgtOoRHjstgVFwll3xZ+gOwklpnB8oea+rLFl1DWL+XtmhsAsNv7HyZCs8pTCz4e dWEeLacOC3zJNOR1mebzaQKAqAcGntxvnL0tLLnmwUxPYfWbThRLVUNhJZd3Y0RjBkIp xN6O0aC8PFRmVsChmSWdrLWCZN8VhlPCPjTQTyn8HKZ6a6xCWqpw94GeVyQGnyjSqfSf eP7hAe3ZDxxOVTdKNe83H687pTx24rcfyqaKrqb+m+uQ91xDXrCRcvcoQV7mSmnKz8VX Id+kD5h7158yeBGHntGukHUYyfdLJHUgx8emdV1edBkigc5mrqsz1tmrHwKbrmaaq3zY Ox9A== X-Gm-Message-State: AOJu0YziHUgo1IhgEd0Vrd+0L3FvL7OfYkBRn163JgXZHe5KrkZxy2Al nT6bST7+Q7Ezqx78dCP78RdfwGXRcCjeqLaCKkbhJFJzKJ0nfIZTbPIVd8Zg7vD5z4zn39rNWz9 qJmAGPspOtQtGGbo9SRypqWGVbcDwYQ== X-Google-Smtp-Source: AGHT+IHo/Hcua6t9LIIyZBE8nSmsVF6pyzkpWhlto+kjicniY7WAD/WaYrS4TM6u0reHjDotUdBnSpJIIafq8KAGf4U= X-Received: by 2002:a05:6808:1b29:b0:3c8:69b6:9b78 with SMTP id 5614622812f47-3d1e349b992mr17845274b6e.29.1717514716517; Tue, 04 Jun 2024 08:25:16 -0700 (PDT) MIME-Version: 1.0 References: <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com> In-Reply-To: <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com> From: Ron Johnson Date: Tue, 4 Jun 2024 11:25:05 -0400 Message-ID: Subject: Re: Purpose of pg_dump tar archive format? To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000931ced061a120edd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000931ced061a120edd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 4, 2024 at 10:43=E2=80=AFAM Adrian Klaver wrote: > On 6/4/24 05:13, Ron Johnson wrote: > > It doesn't support compression nor restore reordering like the custom > > format, so I'm having trouble seeing why it still exists (at least > > without a doc warning that it's obsolete). > > pg_dump -d test -U postgres -Ft | gzip --stdout > test.tgz > Who's got meaningful databases that small anymore? And if you've got meaningfully sized databases, open port 5432 and move them using pg_dump. --000000000000931ced061a120edd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Jun 4, 2024 at 10:43=E2=80=AFAM A= drian Klaver <adrian.klaver= @aklaver.com> wrote:
On 6/4/24 05:13, Ron Johnson wrote:<= br> > It doesn't support compression nor restore reordering like the cus= tom
> format, so I'm having trouble seeing why it still exists (at least=
> without a doc warning that it's obsolete).

pg_dump -d test -U postgres -Ft=C2=A0 | gzip --stdout > test.tgz

Who's got meaningful databases that small = anymore?

And if you've got meaningfully=C2= =A0sized databases, open port 5432 and move them using pg_dump.
=
--000000000000931ced061a120edd--