Thread: Pg dump of parent table instead of taking child table
Hi
We are trying to take parent table backup included all child tables data into dump plan format.but we are getting failed to achieve.
Please help me on these.
Thanks
Sathishreddy
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
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 PM 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 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
There is no such option "--loading-via-parent-root"
Check for existing options here:
https://www.postgresql.org/docs/14/app-pgdump.html
Check for existing options here:
https://www.postgresql.org/docs/14/app-pgdump.html
--
Holger Jakobs, Bergisch Gladbach
Tel. +49 178 9759012
Holger Jakobs, Bergisch Gladbach
Tel. +49 178 9759012
Am 13. September 2024 15:11:59 MESZ schrieb Sathish Reddy <sathishreddy.postgresql@gmail.com>:
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 PM 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 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
On Friday, September 13, 2024, Holger Jakobs <holger@jakobs.com> 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’s actually named —load-via-partition-root ; close enough if going from memory I’d say…but better still to copy and paste real commands or reproducible scripts.
David J.
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 PM 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 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
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=custom --load-via-partition-root > bet.sql
On Fri, Sep 13, 2024, 9:54 PM 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 PM 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 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