Re: Pg dump of parent table instead of taking child table

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org, Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>, Crunchy Bridge Support <bridge-support(at)crunchydata(dot)com>
Subject: Re: Pg dump of parent table instead of taking child table
Date: 2024-09-13 12:54:19
Message-ID: ea7b3fca-5270-4fb5-b295-6c9b9c94e25f@ewie.name
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sathish Reddy 2024-09-13 13:11:59 Re: Pg dump of parent table instead of taking child table
Previous Message Sathish Reddy 2024-09-13 11:30:05 Pg dump of parent table instead of taking child table