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 1sp795-00GgwY-Gw for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 14:19:36 +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 1sp795-003p6B-9A for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 14:19:35 +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 1sp75l-003hqr-PG for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 14:16:09 +0000 Received: from mail-oa1-x36.google.com ([2001:4860:4864:20::36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sp75e-000yVk-Nb for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 14:16:08 +0000 Received: by mail-oa1-x36.google.com with SMTP id 586e51a60fabf-277e4327c99so490936fac.0 for ; Fri, 13 Sep 2024 07:16:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726236961; x=1726841761; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=lwjAhaSyWdpOpKjDLLxg1W0+vJEfm1A5X5QP7fSfNFw=; b=Dkt1t7tTdaFMUxcg4X31RcpGzkNPbFDTc5Q/afdWWFNnXG2GCQKuVvdNCS7nrFNJgs OmBHFZ8TzbDhHnyz7JY9gryDumR48cY9zsy+09DJxhAElcFHE+SLl80IfWfQ0FNnWH6a p55K6s+cKDyGrBx05W4gOwKYiz89Au7s/xiklX0sGmiLAMuAY3xe6VbDHcRRnifi8U4Z iPicmBs5YGcDLn0peZe6LKf6S41NbxJKWB4eSPZJl483iWozJvLyFXhHs7g2s8mUYi2h sZMlUI7F3k8ffDpEUm12kB57nyye+WIQG0OeDop4K41A64ZGRWpXUayEc/MQ2x/7bZvI dhng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726236961; x=1726841761; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=lwjAhaSyWdpOpKjDLLxg1W0+vJEfm1A5X5QP7fSfNFw=; b=iUjlr7U+zaqmpRvsXtQ69GxzhtUzSBF8Q2q4mr8cS6rLwyIMt8bzokUMB6Csdwr1KK 7oAXTQDJzEeHsB3OHR4qqxzvCvzLa983rXorb8Zivaiwpkhazeg9rqkVi1WKiXzNsUzN i0uQnc0Ztt4dVyR3AAByfb7btAF3mq9wmmz0Lvknj9SjjjP5b2ayPREICMSd2UmebiZm xB+PM5ZSy+MZmtWpBGVBsv93GVSKc2e52wacPnkZJWSe1LdX2oy1q2dzyCtghRIMjAgy QlZU1rs6VkiRZEg6HBQzfVdJPdkAf+IzuTMrILW3LQDe3dcXa61xFt3IltGoqfz9dhHz mG2g== X-Gm-Message-State: AOJu0YwI6y7IgFmlHGtGIOzr77F7p5nCtX19rwYJfuri0RpU641a9vcQ VUkACNy1s8CN5h8QcIsZm6XxjHKDVpmUFYAxGt8wf0uAu44BXtc2s9S1A9IWLUYbd3+pL11vEIN APgj684nlrBj2bWtUIxxQtdWllCumaJyX X-Google-Smtp-Source: AGHT+IHD70lxdP0bIP6s7r+ArOoOi8tArZhLYXOP1s6dKhu8dawbXiCp0Ao6ydro0r3hkcyGPjUB9y5b5ReCbJ/WOVM= X-Received: by 2002:a05:6871:24d7:b0:254:affe:5a05 with SMTP id 586e51a60fabf-27c689a31e5mr1857593fac.21.1726236961541; Fri, 13 Sep 2024 07:16:01 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a8a:e0e:0:b0:557:c384:fb61 with HTTP; Fri, 13 Sep 2024 07:16:00 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Fri, 13 Sep 2024 07:16:00 -0700 Message-ID: Subject: Re: Pg dump of parent table instead of taking child table To: Holger Jakobs Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000e417be062200dc09" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e417be062200dc09 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, September 13, 2024, Holger Jakobs wrote: > There is no such option "--loading-via-parent-root" > > Check for existing options here: > > https://www.postgresql.org/docs/14/app-pgdump.html > > It=E2=80=99s actually named =E2=80=94load-via-partition-root ; close enough= if going from memory I=E2=80=99d say=E2=80=A6but better still to copy and paste real comm= ands or reproducible scripts. David J. --000000000000e417be062200dc09 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, September 13, 2024, Holger Jakobs <holger@jakobs.com> wrote:
There is no such option "--loading-via-parent-roo= t"

Check for existing options here:

https://www.p= ostgresql.org/docs/14/app-pgdump.html

<= /div>

It=E2=80=99s actually named =E2=80=94= load-via-partition-root ; close enough if going from memory I=E2=80=99d say= =E2=80=A6but better still to copy and paste real commands or reproducible s= cripts.

David J.

--000000000000e417be062200dc09--