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 1sEZyF-002HnO-PF for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 19:37:25 +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 1sEZyC-0028mU-IM for pgsql-general@arkaria.postgresql.org; Tue, 04 Jun 2024 19:37: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 1sEZyC-0028ku-6M for pgsql-general@lists.postgresql.org; Tue, 04 Jun 2024 19:37:20 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sEZy9-003T0w-P6 for pgsql-general@lists.postgresql.org; Tue, 04 Jun 2024 19:37:18 +0000 Received: by mail-pj1-x102b.google.com with SMTP id 98e67ed59e1d1-2c1a9b151bcso4551883a91.3 for ; Tue, 04 Jun 2024 12:37:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717529836; x=1718134636; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=wijvBSWlSH23jBzUCdMhuS8dCEWmrzop5pG7Fcy8hlc=; b=nSFey43knLcfMijDvlVDpx9vHaiz0jJruuWdEURUhuUUToe+h6p/5wWGdJJd5S5Or5 RvW3da2Chu7KrFZJmC6KbqIBqM/FY/K5nRr6Xqko66wXX9dF1AUWY09mN4Fmy99TS9Z0 ZGW+hm9YiW+p3LSoKfh5K57D3haSgu+LiiUw0as5MGybfbqNKpz5Af7strrGen6CqiK5 w56stSUzvDN+qU4an/wrMHvRbDm6lEXctKvYvSr4tFqeIeb/pn8ptQbvLRvIpxWE/rSm VdrCXfqTOzD6JmSFxjL1VrqmxXK6F//+NHrOF2DOvGkf6SkcWhOmL/Pb1GMdiWPtLiel mUJg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717529836; x=1718134636; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=wijvBSWlSH23jBzUCdMhuS8dCEWmrzop5pG7Fcy8hlc=; b=up78AYEX1ezi3vXe1n4+rQX0ZfdnVJR6WvxyssqX6m57DVBigFsbAL9SdznuVS0Bux Z6TmFMmQ+9zVUV/TW3eGNGzi8ehtWzEI4w3yNrN48KCRAMEv/yKOw2SXoiOncaqCUAy2 a7HLFdoykcq6u66Gvyw3FPpJdHBH9H/GK3hq1+bKckI7Zus5j3qFroxj/A+QCPYqcoSq cQcKfBBGEh5aQVUi/aXQVJamjL0w0WNGseX81X6KaMOzhMVLlv8rcWgjJuNxWMUuT45x NlHxw+YX/YtjI0MmDOjadjZGW5U500wRAECk/pPpkFmdOakRylAR5ifkONSE/t0HFDfN cR6w== X-Gm-Message-State: AOJu0YwgQ+VygEyt7B39DCALgeAyf9irNGbRHxQXBDWfj/i3pqh8DlyW 7EwzjxLFkMEqLcjG3nzFQoMTmRk9zkIt8bJ9ZshGmYC0gXDCcPGVLfGJGg== X-Google-Smtp-Source: AGHT+IGMOLRFCoh4ab/YEuQeQI0rYpLKkVuhX0AX/Pd/igMNEcJg3RYwaOlKZQPpgamyNtm6lizvcw== X-Received: by 2002:a17:90b:1d06:b0:29b:b5a4:c040 with SMTP id 98e67ed59e1d1-2c27db68db9mr431168a91.46.1717529836264; Tue, 04 Jun 2024 12:37:16 -0700 (PDT) Received: from [192.168.1.3] (c-76-140-27-218.hsd1.ut.comcast.net. [76.140.27.218]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2c1c28316dbsm8539386a91.39.2024.06.04.12.37.15 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 04 Jun 2024 12:37:15 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------FXihoK3d6ZFG19pG5MJGTlR0" Message-ID: <086cd168-7c38-458d-9c8e-be1567bbfdeb@gmail.com> Date: Tue, 4 Jun 2024 13:37:14 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Purpose of pg_dump tar archive format? To: pgsql-general@lists.postgresql.org References: <25e9749c-ff38-4832-9b26-386cac33b3d8@aklaver.com> <7005ac8c-2f83-4122-9172-04bca268f987@aklaver.com> <4b28e899-d802-43ce-b20b-655a9077f08f@gmail.com> Content-Language: en-CA From: Rob Sargent In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------FXihoK3d6ZFG19pG5MJGTlR0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 6/4/24 13:15, Ron Johnson wrote: > On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote: > > > > On 6/4/24 11:40, Shaheed Haque wrote: > > > > We use it. I bet lots of others do too. > > > > > > Of course.  There are lots of small, real, useful databases in the > wild. > > But why tar instead of custom? That was part of my original question. > That I can't say.  Familiarity?  Fewer keystrokes? --------------FXihoK3d6ZFG19pG5MJGTlR0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

On 6/4/24 13:15, Ron Johnson wrote:
On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent <robjsargent@gmail.com> wrote:


On 6/4/24 11:40, Shaheed Haque wrote:
>
> We use it. I bet lots of others do too.
>
>

Of course.  There are lots of small, real, useful databases in the wild.
 
But why tar instead of custom? That was part of my original question.

That I can't say.  Familiarity?  Fewer keystrokes?


--------------FXihoK3d6ZFG19pG5MJGTlR0--