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 1sp6zp-00Gfdp-KR for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 14:10:02 +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 1sp6zp-003dOm-Ag for pgsql-admin@arkaria.postgresql.org; Fri, 13 Sep 2024 14:10:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp6zo-003dOe-Vk for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 14:10:00 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp6zk-00106n-Ru for pgsql-admin@lists.postgresql.org; Fri, 13 Sep 2024 14:10:00 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id B3202380A01 for ; Fri, 13 Sep 2024 16:09:56 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id fYY9KGeZtXRg for ; Fri, 13 Sep 2024 16:09:56 +0200 (CEST) Received: from [127.0.0.1] (dynamic-176-006-054-211.176.6.pool.telefonica.de [176.6.54.211]) by rs.plausibolo.de (Postfix) with ESMTPSA id 3F4B53809F5 for ; Fri, 13 Sep 2024 16:09:56 +0200 (CEST) Date: Fri, 13 Sep 2024 16:09:55 +0200 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Subject: Re: Pg dump of parent table instead of taking child table User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----5053Q3C40PUXMOEYI09RYFBY022HSP Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------5053Q3C40PUXMOEYI09RYFBY022HSP Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable There is no such option "--loading-via-parent-root" Check for existing options here:=20 https://www=2Epostgresql=2Eorg/docs/14/app-pgdump=2Ehtml --=20 Holger Jakobs, Bergisch Gladbach=20 Tel=2E +49 178 9759012 Am 13=2E September 2024 15:11:59 MESZ schrieb Sathish Reddy : >We are using 14 version >Pg_dump with -Fp and --loading-via-parent-root option > > > >Database name is better and schema is better=2E =2E=2E > > > >Thanks > >Sathishreddy > >On Fri, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold wr= ote: > >> On 2024-09-13 13:30 +0200, Sathish Reddy wrote: >> > We are trying to take parent table backup included all child tables d= ata >> > into dump plan format=2Ebut we are getting failed to achieve=2E >> >> 1) Which Postgres version? >> >> 2) What pg_dump options did you use? >> >> 3) What output/error do you get? >> >> 4) What does the database schema look like? Are you using table >> inheritance or foreign keys for the parent-child relationship? >> >> -- >> Erik >> ------5053Q3C40PUXMOEYI09RYFBY022HSP Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
There is no such option "--loadi= ng-via-parent-root"

Check for existing options here:

https://www= =2Epostgresql=2Eorg/docs/14/app-pgdump=2Ehtml
--
Holger Jakobs, Bergisch Gladbach
T= el=2E +49 178 9759012


Am 13=2E September 2024 15:11:59 MESZ schrieb Sathish Reddy <= sathishreddy=2Epostgresql@gmail=2Ecom>:

We are using 14 version
Pg_dump with  -Fp and --loading-via-parent-root option 



Database name is be= tter and schema is better=2E =2E=2E



Thanks 

Sathishreddy <= /p>


On Fr= i, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold <ewie@ewie=2Ename> w= rote:
On 2024-09-13 13:30 +0200, = Sathish Reddy wrote:
> We are trying to take parent table backup included all child tables d= ata
> into dump plan format=2Ebut we are getting failed to achieve=2E

1) Which Postgres version?

2) What pg_dump options did you use?

3) What output/error do you get?

4) What does the database schema look like?  Are you using table
   inheritance or foreign keys for the parent-child relationship= ?

--
Erik
------5053Q3C40PUXMOEYI09RYFBY022HSP--