From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
cc: Ron Johnson <ronljohnsonjr@gmail.com>,
        pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Purpose of pg_dump tar archive format?
In-reply-to: <7005ac8c-2f83-4122-9172-04bca268f987@aklaver.com>
References: <CANzqJaAHOSNiOhe4D2hOBB46=puWQOZb=s=VQdNmUSOtOmRG5A@mail.gmail.com> <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com> <CANzqJaCMR-5eLMYy0ukywWeKpwySCAMQRrgKmW7A2CZ-mr9+0Q@mail.gmail.com> <7005ac8c-2f83-4122-9172-04bca268f987@aklaver.com>
Comments: In-reply-to Adrian Klaver <adrian.klaver@aklaver.com>
	message dated "Tue, 04 Jun 2024 08:33:47 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <478302.1717520038.1@sss.pgh.pa.us>
Date: Tue, 04 Jun 2024 12:53:58 -0400
Message-ID: <478303.1717520038@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/478303.1717520038%40sss.pgh.pa.us>
Precedence: bulk

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> If you don't need the tar format then don't use it.

Indeed.  FTR, I think the original motivation for tar format was to
have a "standard" structured output format that could be manipulated
with tools other than pg_restore.  Years later, we added the directory
format which could be argued to serve the same purpose.  But nobody
particularly wanted to remove the tar functionality, especially since
the two were made to be compatible:

commit 7f508f1c6b515df66d27f860b2faa7b5761fa55d
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:   Sun Jan 23 23:10:15 2011 +0200

    Add 'directory' format to pg_dump. The new directory format is compatible
    with the 'tar' format, in that untarring a tar format archive produces a
    valid directory format archive.

			regards, tom lane