Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ogRrU-0006eE-0t for pgsql-docs@arkaria.postgresql.org; Thu, 06 Oct 2022 14:28:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ogRrS-00059I-To for pgsql-docs@arkaria.postgresql.org; Thu, 06 Oct 2022 14:28:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ogRrS-00057t-Mo for pgsql-docs@lists.postgresql.org; Thu, 06 Oct 2022 14:28:30 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ogRrQ-0003BM-0c for pgsql-docs@lists.postgresql.org; Thu, 06 Oct 2022 14:28:29 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1ogRrP-002JKX-6n; Thu, 06 Oct 2022 10:28:27 -0400 Date: Thu, 6 Oct 2022 10:28:27 -0400 From: Bruce Momjian To: jcarson@fastmail.com, pgsql-docs@lists.postgresql.org Subject: Re: request clarification on pg_restore documentation Message-ID: References: <166446181317.661.16517798061228916974@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <166446181317.661.16517798061228916974@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thread moved to hackers. --------------------------------------------------------------------------- On Thu, Sep 29, 2022 at 02:30:13PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/app-pgrestore.html > Description: > > pg_restore seems to have two ways to restore data: > > --section=data > > or > > --data-only > > There is this cryptic warning that --data-only is "similar to but for > historical reasons different from" --section=data > > But there is no further explanation of what those differences are or what > might be missed or different in your restore if you pick one option or the > other. Maybe one or the other option is the "preferred current way" and one > is the "historical way" or they are aimed at different types of use cases, > but that's not clear. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson