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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sEVO7-001pBm-1D
	for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 14:43:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sEVO6-00HKKE-Ap
	for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 14:43:46 +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 <adrian.klaver@aklaver.com>)
	id 1sEVO5-00HKK5-DZ
	for pgsql-general@lists.postgresql.org; Tue, 04 Jun 2024 14:43:45 +0000
Received: from fhigh1-smtp.messagingengine.com ([103.168.172.152])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sEVO2-003Pjj-Fo
	for pgsql-general@postgresql.org; Tue, 04 Jun 2024 14:43:44 +0000
Received: from compute2.internal (compute2.nyi.internal [10.202.2.46])
	by mailfhigh.nyi.internal (Postfix) with ESMTP id 2E52811400CB;
	Tue,  4 Jun 2024 10:43:41 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute2.internal (MEProxy); Tue, 04 Jun 2024 10:43:41 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm3; t=1717512221;
	 x=1717598621; bh=QhTu9oNwx0FoE7/wROLutZa+Dj4A2zYEzuCW6PoC7X4=; b=
	OIbvF7tImRNXd1iyOeWrwKd/s39jYpctCsjAAyA95FgGs2nSmdCZQkyII5sH/qWx
	e6tyC2uC1G+dnsFy3Vsl6madv6nvSjXbFAsMMR31Cu0Eg7xeTUs0V1/kYaJEqyUV
	loySN5JJYit/xkP/rWsxNpanHW1TiCQRqOjKY8LRTDizJxt0eRZ1wF64Ga9olJpm
	omrAOl8Xdr5Rcg/X9wY8+TO8eVOVfcG2LqmO7adldLmgKDX0XAUkaYmSJGRy6rms
	sy/V8St8U01ldJzqdZoxfa3KfHkZ0V051bmZy5s3GLwCBYT6QSiVDRaFmkH+tBrY
	1bAYVwtlMneslU2ilR1Dzw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1717512221; x=
	1717598621; bh=QhTu9oNwx0FoE7/wROLutZa+Dj4A2zYEzuCW6PoC7X4=; b=K
	cCQvsZSH1wVsYjlC0vA+Vfs+HyAKEFIS+Ah22fjuUb4ucEoNkwNwp+0VpIE7FxMp
	hCMih8zfNraXCYZ6gc4BhK0pEmr7vJw8lqJB1HykZ2e/i2gSXKIck9z/8FLGp0XN
	tDH9XWnejEDATSZsoLPVw752P9FXG1tTzIeaGInVs1MiI0VOJtskfXbcgQjB0aBv
	zdxd0Ue7JqEamT3GV6VR9/BImMXi3BQwkvEIMuh7iNntzm+KobpZGH0Nu0AWlE79
	Zqb+XR2gBoSlDjZIQY0WHfy35U+nOwFH5EhaSolVXHU6vLtXlK8HdHYxWkSIN7xI
	MvG9yYOKRN8Z2vzpoKRiQ==
X-ME-Sender: <xms:HChfZq2MQDayxp8lCSy3OI1ZiexrhgVFOZX1YXX-VZyyhlV0keoTFw>
    <xme:HChfZtFvURUW1Lj3u-xjH4KzNXUIv7lUFsOoBPKorYai1dreare6GQbLVy0v0IEVV
    udHEH0IV8k0ZFI>
X-ME-Received: <xmr:HChfZi66Lohu6u5dQXl67E_zLePcqyBIiy2k9av0j0kBBoRxUwfU6q0a-qb8uDHo6a0cO6zb15eJdSi4wK3iWVB2mG3pGA>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdelgedgjeehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtje
    ertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhk
    lhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepiedvhfeihe
    ehgeeuieeljeeitedtjeehudegfeelkedvleekhedtgfeiffefkedunecuvehluhhsthgv
    rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvh
    gvrhesrghklhgrvhgvrhdrtghomh
X-ME-Proxy: <xmx:HChfZr0FdsJFExMSZVSpWTcMtziPHwJ5uEWlxQKwh3xUqCxNxsy7Uw>
    <xmx:HChfZtED6EFccb6bSpDrae3ZEX7mQbSKtDrs8wcRLcl1-vPBS0tHDg>
    <xmx:HChfZk8CysaWGDo6Axqjc9nGeI3ygXdmlXo-LfYog3nRva3QZhoJ-w>
    <xmx:HChfZimHhzeLf6g4h6qoU52r6W69a_C9YwziHowM-96uelcB9CjVnw>
    <xmx:HShfZiRaR7ILOGHl7W-9zdxWy_2v1NpKvNc_oduR_X5fBNZF9K6_5g2i>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue,
 4 Jun 2024 10:43:40 -0400 (EDT)
Message-ID: <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com>
Date: Tue, 4 Jun 2024 07:43:39 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Purpose of pg_dump tar archive format?
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <CANzqJaAHOSNiOhe4D2hOBB46=puWQOZb=s=VQdNmUSOtOmRG5A@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaAHOSNiOhe4D2hOBB46=puWQOZb=s=VQdNmUSOtOmRG5A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/25e9749c-ff38-4832-9b26-386cac33b3d8%40aklaver.com>
Precedence: bulk

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com