MIME-Version: 1.0
References: 
 <CA+M9Y+BqMNG4Fa+sgU+HG41a8pKw1P1skK0H7OhBxBXf+jE62Q@mail.gmail.com>
 <ea7b3fca-5270-4fb5-b295-6c9b9c94e25f@ewie.name>
In-Reply-To: <ea7b3fca-5270-4fb5-b295-6c9b9c94e25f@ewie.name>
From: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Date: Fri, 13 Sep 2024 18:41:59 +0530
Message-ID: 
 <CA+M9Y+AzCxL0B5yJnLD3QU9H71bX8a9Eua9=d2gciY2oKDVY2w@mail.gmail.com>
Subject: Re: Pg dump of parent table instead of taking child table
To: Erik Wienhold <ewie@ewie.name>
Cc: pgsql-admin@lists.postgresql.org,
	Keith Fiske <keith.fiske@crunchydata.com>,
	Crunchy Bridge Support <bridge-support@crunchydata.com>
Content-Type: multipart/alternative; boundary="000000000000a2dffe0621fff8bf"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BM9Y%2BAzCxL0B5yJnLD3QU9H71bX8a9Eua9%3Dd2gciY2oKDVY2w%40mail.gmail.com>
Precedence: bulk

--000000000000a2dffe0621fff8bf
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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


Database name is better and schema is better. ..


Thanks

Sathishreddy

On Fri, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold <ewie@ewie.name> wrote:

> On 2024-09-13 13:30 +0200, Sathish Reddy wrote:
> > We are trying to take parent table backup included all child tables dat=
a
> > into dump plan format.but we are getting failed to achieve.
>
> 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
>

--000000000000a2dffe0621fff8bf
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><p dir=3D"ltr">We are using 14 version <br>
Pg_dump with=C2=A0 -Fp and --loading-via-parent-root option=C2=A0</p><p dir=
=3D"ltr"><br></p><p dir=3D"ltr"><br></p><p dir=3D"ltr">Database name is bet=
ter and schema is better. ..</p><p dir=3D"ltr"><br></p><p dir=3D"ltr"><br><=
/p><p dir=3D"ltr">Thanks=C2=A0</p><p dir=3D"ltr">Sathishreddy=C2=A0</p></di=
v>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri=
, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold &lt;<a href=3D"mailto:ewie@ew=
ie.name" target=3D"_blank" rel=3D"noreferrer">ewie@ewie.name</a>&gt; wrote:=
<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bord=
er-left:1px #ccc solid;padding-left:1ex">On 2024-09-13 13:30 +0200, Sathish=
 Reddy wrote:<br>
&gt; We are trying to take parent table backup included all child tables da=
ta<br>
&gt; into dump plan format.but we are getting failed to achieve.<br>
<br>
1) Which Postgres version?<br>
<br>
2) What pg_dump options did you use?<br>
<br>
3) What output/error do you get?<br>
<br>
4) What does the database schema look like?=C2=A0 Are you using table<br>
=C2=A0 =C2=A0inheritance or foreign keys for the parent-child relationship?=
<br>
<br>
-- <br>
Erik<br>
</blockquote></div>

--000000000000a2dffe0621fff8bf--