MIME-Version: 1.0
References: 
 <CA+M9Y+BqMNG4Fa+sgU+HG41a8pKw1P1skK0H7OhBxBXf+jE62Q@mail.gmail.com>
 <ea7b3fca-5270-4fb5-b295-6c9b9c94e25f@ewie.name>
 <CA+M9Y+AzCxL0B5yJnLD3QU9H71bX8a9Eua9=d2gciY2oKDVY2w@mail.gmail.com>
 <4996c1e7-2eec-4fae-ad75-b337cfad65de@ewie.name>
In-Reply-To: <4996c1e7-2eec-4fae-ad75-b337cfad65de@ewie.name>
From: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Date: Fri, 13 Sep 2024 23:08:36 +0530
Message-ID: 
 <CA+M9Y+B8bTqNYXUfU+TynvZGgq6MA_6Cbt7MPF9OkWApksHgvQ@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="00000000000021fb9b062203b2c0"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BM9Y%2BB8bTqNYXUfU%2BTynvZGgq6MA_6Cbt7MPF9OkWApksHgvQ%40mail.gmail.com>
Precedence: bulk

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

Thanks we got solution for these

pg_dump -h
ppbet-betplacement-prod-db-00.chllgfpshkd5.eu-west-1.rds.amazonaws.com -U
postgres -d betplacement -t betplacement.bet --data-only --format=3Dcustom
--load-via-partition-root > bet.sql

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

> On 2024-09-13 15:11 +0200, Sathish Reddy wrote:
> > We are using 14 version
> > Pg_dump with  -Fp and --loading-via-parent-root option
> >
> >
> >
> > Database name is better and schema is better. ..
>
> But how are the tables defined, i.e., the CREATE TABLE statements?
>
> Are we talking about table partitions when you're possibly using
> --load-via-partition-root (as noted downthread)?
>
> > On Fri, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold <ewie@ewie.name> wr=
ote:
> >
> > > On 2024-09-13 13:30 +0200, Sathish Reddy wrote:
> > > > We are trying to take parent table backup included all child tables
> data
> > > > 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
>

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

<p dir=3D"ltr">Thanks we got solution for these </p>
<p dir=3D"ltr">pg_dump -h <a href=3D"http://ppbet-betplacement-prod-db-00.c=
hllgfpshkd5.eu-west-1.rds.amazonaws.com">ppbet-betplacement-prod-db-00.chll=
gfpshkd5.eu-west-1.rds.amazonaws.com</a> -U postgres -d betplacement -t bet=
placement.bet --data-only --format=3Dcustom --load-via-partition-root &gt; =
bet.sql</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri=
, Sep 13, 2024, 9:54=E2=80=AFPM Erik Wienhold &lt;<a href=3D"mailto:ewie@ew=
ie.name">ewie@ewie.name</a>&gt; wrote:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex">On 2024-09-13 15:11 +0200, Sathish Reddy wrote:<br>
&gt; We are using 14 version<br>
&gt; Pg_dump with=C2=A0 -Fp and --loading-via-parent-root option<br>
&gt; <br>
&gt; <br>
&gt; <br>
&gt; Database name is better and schema is better. ..<br>
<br>
But how are the tables defined, i.e., the CREATE TABLE statements?<br>
<br>
Are we talking about table partitions when you&#39;re possibly using<br>
--load-via-partition-root (as noted downthread)?<br>
<br>
&gt; On Fri, Sep 13, 2024, 6:24=E2=80=AFPM Erik Wienhold &lt;<a href=3D"mai=
lto:ewie@ewie.name" target=3D"_blank" rel=3D"noreferrer">ewie@ewie.name</a>=
&gt; wrote:<br>
&gt; <br>
&gt; &gt; On 2024-09-13 13:30 +0200, Sathish Reddy wrote:<br>
&gt; &gt; &gt; We are trying to take parent table backup included all child=
 tables data<br>
&gt; &gt; &gt; into dump plan format.but we are getting failed to achieve.<=
br>
&gt; &gt;<br>
&gt; &gt; 1) Which Postgres version?<br>
&gt; &gt;<br>
&gt; &gt; 2) What pg_dump options did you use?<br>
&gt; &gt;<br>
&gt; &gt; 3) What output/error do you get?<br>
&gt; &gt;<br>
&gt; &gt; 4) What does the database schema look like?=C2=A0 Are you using t=
able<br>
&gt; &gt;=C2=A0 =C2=A0 inheritance or foreign keys for the parent-child rel=
ationship?<br>
<br>
-- <br>
Erik<br>
</blockquote></div>

--00000000000021fb9b062203b2c0--